Toggles for Sub-Totals and Grand-Totals on Matrixes
We can now turn Row Totals on or off, and that turns all subtotals and grand totals on or off. It would be great to be able to have the option to have the Grand Totals on without the subtotals, or have the subtotals on without the Grand Totals.
Hi, take a look at this idea:
[Deleted User] commented
we actually need to have a seperate toggle to both sub totals and grand totals. You want to be able to show totals at different levels in view be it grand or subtotal
A similar thread with 120 votes also exists for this.
This is a must to decide which of dimensions should have subtotals and which not. Right now you can only have subtotals for all dims, or any of it = grand total for the column/row is not available too. This should be changed.
This is possibly a duplicate of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-buttons
The two ideas might best me merged in some way. See also https://ideas.powerbi.com/forums/265200-power-bi?query=subtotals