Need help with Adding subtotals to Table Visual

[RolinMartis1]

Hi Team,

I need to build a Table visulal like below with Sub Totals.

But I am not able to add the sub Totals in Table Visual.

The Matryx Visual shows the heirarchy View like below

Is there a way i can build a chart with subtotals on . I want every row to be shown separately instead of heirarchy.

Regards,

Rolin

[Kishore_KVN · Accepted solution]

Hello @RolinMartis1  you can achieve it in one way, 

>> Select the matrix visual>>Go to visual format>>Go to Row Headers>>Under Options>> Turn off stepped layout. 

output may look something like this as per the example that I have considered.

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[RolinMartis1]

Thanks alot @Kishore_KVN . Its exactly what i wanted.  But the problem is I am using parameters to dynamically change my rows. something like below

Everytime i select a different  option from attribute 1 ,2 ,3 dropdown the heirarchy colapses. 

Is there a way i can have the heirarchy always expanded.

Regards,

Rolin