Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Please check enclosed file..
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
];