Forum Discussion
Column header sorting in multi dimensional Matrix
I am using Multidimensional Matrix where I have Fiscal Month as 1st Level and for each Fiscal Month I have Actual and Budget numbers. I am using excel data for this report. In second level, by de...
Hi sanju_g,
Could you please share your sample data and excepted result to me ? So that I can help with it.
Regards,
Frank
Hello,
Below is by data format. If you see row 2 below where it says Actual & Budget for each Fiscal Month. I want this to be Budget and Actual, instead of the way it displayed.
| Fiscal Period | 201801 | 201802 | 201803 | 201804 | ||||
| Initiative Id | Actual | Budget | Actual | Budget | Actual | Budget | Actual | Budget |
| C00021 | 311233 | 331124 | 55413 | 331124 | 62567 | 331124 | ||
| D00555-2 | 2264794 | -7188687 | ||||||
| D00555-3 | ||||||||
| D00440 | ||||||||
| D00646 |
Thanks & Regards,
Sanjeev