Multiple Rows in a Final Total

[Uzi2019]

Hi Experts,

I want to show table that is identical to given screen shot. is there any way to show multiple rows in Final total like that?

Thank you in advance...

Waiting for your reply.

[MFelix · Accepted solution]

Hi @Uzi2019 ,

Theres is no such option to make the visualization has you are placing it here.

You can have two option one is to create tow table with different groupings and then make one on top of the of the other. 

Other option is to create dimensiont table and measure that agregate the information has your need but believe that having so many diffent options that will cause a big increase in your model.

The only change was that I added a column to the model sayning Total as the first level of thesecond table.

[Uzi2019]

@MFelix Thank you for your reply. Option for 2 different table works for me.