Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

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

Need Help

2 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    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!

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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