Design a matrix with multiple row and column dimensions

[andyor]

What's the best approach to designing a matrix report like this?

Would you have split into 2 tables like below and 'append' together? Or is there some better way?

I currently have all the relevant data in a table but don't know how to design the visualisation.

The WK data is Turnover for each of the Cohorts. 

I currently have 2 matrix's and it all just looks a bit silly - column headers are duplicated, column widths are different. I do have to do some form of rank to display the triangle correctly, but I'm more worried about how to display the core information in a format that makes sense

[Gokul_G16]

Hi, @andyor ,

Please try this bewlow snap there reflect option is "Cell element", "Spefic Column ", and can please use your view bar number Count "FX" 

Hope you get this things useful, Please like it me 🙂

Thanks,
Gokul

[andyor]

Hi Gokul. That's nothing like I'm trying to achieve. I wonder now how well the problem has been presented by myself 

[Gokul_G16]

Hey @andyor ,

Can you please brefly your requirement to get it Achive ..

Thanks,
Gokul

[andyor]

Firstly, I have it a column named 'CashTurnover' and another column named 'WK'. There are multiple data rows for each WK e.g., WK0, WK1, WK2 etc. 

Now I want to create a new measure that returns for the sum of all row 'CashTurnover' accumulated up until that week:

For example:

WK0 : sum of all 'CashTurnover' for WK0

WK1: sum of all 'CashTurnover' for WK0 + WK1

WK2: sum of all 'CashTurnover' for WK0 + WK1 + WK2 

etc

[Gokul_G16]

Hi @andyor ,

Please find the below snap.

Can you please try this way achive your scnario for that.

If I answered the your question,Please kudoo me..

Thanks 
Gokul