Best table chart

[Alanlu]

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!

[amitchandak · Accepted 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]

Thanks amitchandak!