Forum Discussion
Need help with Adding subtotals to Table Visual
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
Hello Anonymous 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!!
2 Replies
Hello Anonymous 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!!
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