Matrix Table: Difference include the table (next level drill down)

[Anonymous]

Hi Team,

I have created Matrix table with drill down 3 levels however I can't include the difference for all level,

kindly advise me.

The below difference is separate table, I want to combine one table

Thanks,

W_Dk

[Anonymous]

Hi @Anonymous 

Can you please show what the desired outcome should be like? You can use Excel to show a matrix outcome with some dummy data. It seems both rows and columns have hiererchies, how do you want to drill it down? 

Best Regards,
Jing

[Uzi2019]

Hi @Anonymous 

you cannot have difference measure on drill down in metrix hierarchy beacuse hierarchy works for dimension fileds not on numberic / meaures.
Dimension mens product/ dates/year/customer name/ city etc
Measures/ Numeric fileds have to take in value section of metrix visual.

I hope I answered your question!