Key figures in a pivot/straight table

[#1]

I need help in the app design/development. I have data coming on a straight table format like this:

YearMonth	Version (0 for planned, 1 for actual)	Sales
01/2013	0	300
01/2013	1	250
01/2013	1	150
02/2013	0	350
02/2013	1	250

....

I would need to show the data in a following matter:

YearMonth	Actual (version=1)	Planned (version=2)
01/2013	400	300
02/2013	250	350

....

This is a simplified example, there are as many as 5-6 dimensions such as "Version" affecting which rows to pick into the report. So my question is, is it better create the key figures inside the table/report (and how is it done?) or would you rather do it in the load script?

Thank you already in advance!

[MK_QSL]

Please check enclosed file..

[MK_QSL]

You can create an Inline Table in load script...

Load * Inline

[

  VersionID, Version

  0, Planned

  1, Actual

  2, Good

  3, Enough

  4, Far

];

Load *

Inline

[

  YearMonth, VersionID, Sales

  01/2013, 0, 300

  01/2013, 1, 250

  01/2013, 2, 100

  01/2013, 3, 150

  01/2013, 4, 300

  01/2013, 1, 150

  02/2013, 0, 350

  02/2013, 1, 250

  03/2013, 4, 400

  03/2013, 3, 250

  03/2013, 1, 350

];