Forum Discussion

Alanlu's avatar
Alanlu
New Member
3 years ago
Solved

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

 ActualAOPLELY
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!

2 Replies