Forum Discussion
Matrix subtotal
Hi all,
I have a requirement where i have 3 rows in matrix but i need a subtotal at clinetname level and highlight the subtotal. but i am unable to highlight that alone and everylevel is being highlighted. i am unable to see value button enabled when I select the subtotal
Hi jostnachs
Unfortunately, we don't have an option to change the formatting of the highlights for each level of subtotals separately. However, perhaps changing the layout of the matrix could help make things clearer by adjusting the positioning.
For example, this is how it will look with a tabular layout:And this is an outline:
+ If there is just 1 line in the last hierarchies, you can switch off the lowest level subtotal:The pbix with the examples is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
2 Replies
Hi jostnachs
Unfortunately, we don't have an option to change the formatting of the highlights for each level of subtotals separately. However, perhaps changing the layout of the matrix could help make things clearer by adjusting the positioning.
For example, this is how it will look with a tabular layout:And this is an outline:
+ If there is just 1 line in the last hierarchies, you can switch off the lowest level subtotal:The pbix with the examples is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi jostnachs,
I hope the following comments will help you.
In row subtotal enable Per row level and select row level fields just select and enable show subtotal for clinetname level.
Best Regards,
Ajith Kumar
Did I answer your question? Mark my post as a solution!
