Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
@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
@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
Thanks amitchandak!