Matrix remove subtotals for certain columns

[smc]

Any ideas on how to remove the subtotals and grand totals for these two columns (don't need) when in collapse mode?  

I have subtotals currently set to:

Which is perfect in expand mode:

But in collapse mode it shows (first screen).    Thanks

[v-xiaoyan-msft]

Hi@smc，

You may use the drill down function in Martrix to achieve your needs by clicking on this icon  on the visual.

If you want to display the data more visually, you can also change the visual and use the table visual.

Hope it helps.

Best Regards,
Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[HarishKM]

@smc  You have trun off for Address 1 as well. 

If it is work mark my post as solution.

[smc]

Hi and thanks but unfortunately did not work:

[selimovd]

Hey @smc ,

sadly you cannot change that setting dynamically.

So either you can turn it on or off, but there is no possibility to dynamically turn it on or off.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi