Forum Discussion
Best table chart
Hi Guys,
I'm trying to use 'Matrix' to show some data but seems not working in my way.
the data I have is like below and I do not want to unpivit again as I need this format to calculate %
What I want is to display in this way for MTD, QTD and YTD
| Actual | AOP | LE | LY | |
| Gross Sales | ||||
| Gross Profit | ||||
| Contribution Margin | ||||
| EBITA |
But Matrix cannot do it this way, it will be either for values
or for columns
any add-on suggestion that I can use to achieve this?
Thanks!
Alanlu , For the display given in text format, calculation group can be used
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
2 Replies
- amitchandakSuper User
Alanlu , For the display given in text format, calculation group can be used
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
- AlanluNew Member
Thanks amitchandak!