title: BIRT Report Designer - split actual and budget data stored in one table into columns and add a variance
body: <p>I have financial data in the following format in a SQL database and I have to live with this format unfortunately (example dummy data below).</p>
  <p><a href="https://i.stack.imgur.com/EBL0u.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EBL0u.jpg" alt="enter image description here" /></a></p>
  <p>I have however been struggling to get it into the following layout in a BIRT report.</p>
  <p><a href="https://i.stack.imgur.com/9tXj6.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9tXj6.jpg" alt="enter image description here" /></a></p>
  <p>I have tried creating a data cube with Package, Flow and Account as Dimensions and Balance as a Measure, but that groups actual PER and actual YTD next to each other and budget PER and YTD next to each-other etc so is not quite what I need.</p>
  <p>The other idea I had was to create four new calculated columns, the first would only have a value if it were a line for actual and per, the next only if it was actual and ytd etc, but could not get the IF function working in the calculated column.</p>
  <p>What are the options? Can someone point me in the direction of how to best create the above layout from this data structure so I can take it from there?</p>
  <p>Thanks in advance.</p>