Forum Discussion
Matrix remove subtotals for certain columns
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
4 Replies
- selimovdMost Valuable Professional
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 regardsDenisBlog: WhatTheFact.bi - HarishKMSuper User
- smcRegular Visitor
Hi and thanks but unfortunately did not work:
- AnonymousNot applicable
Hismc,
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 YanIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.