Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Matrix Table with dynamic column headers

Hello :),   I have 2 questions for my Matrix table. I need to do a matrix table which includes the Actual values until the current Date and for the rest of the Year the Forecast Values. For Example...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi CNENFRNL ,

     

    thank you for quick help. I would like to do matrix table where each month is a separte column. I think I can adopt the code for the measure.

    The final Matrix table should look like this:

     

    Cost type

    Jan

    		FebMarMayJuneJulyAugSeptOct
    US100xxxxxxxxxxxxxxxxxxxxx

    xxx

    		xxx

     

    So now I would add calculated columns for each month and post your code.

     

    Now the question is, how can I highlight in the column header, which month is an actual or a forecast?

     

    Thank you and best regards,

     

    Albert