Matrix subtotal

[jostnachs]

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

[Ajithkumar_03]

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!

[Ritaf1983 · Accepted solution]

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