Forum Discussion

sanju_g's avatar
sanju_g
New Member
8 years ago

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...
v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

Hi sanju_g,

 

Could you please share your sample data and excepted result to me ? So that I can help with it.

 

Regards,

Frank

  • sanju_g's avatar
    sanju_g
    New Member
    8 years ago

     

    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 Period201801201802201803201804
    Initiative IdActualBudgetActualBudgetActualBudgetActualBudget
    C000213112333311245541333112462567331124  
    D00555-22264794 -7188687     
    D00555-3        
    D00440        
    D00646        

     

    Thanks & Regards,

    Sanjeev