Aaron on 29 Apr 2016 21:22:05
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.
- Comments (6)
RE: Toggles for Sub-Totals and Grand-Totals on Matrixes
I voted. How many vote required before this idea included in the next updates?
RE: Toggles for Sub-Totals and Grand-Totals on Matrixes
Hi, take a look at this idea:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18346846-show-not-show-subtotals
RE: Toggles for Sub-Totals and Grand-Totals on Matrixes
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
RE: Toggles for Sub-Totals and Grand-Totals on Matrixes
A similar thread with 120 votes also exists for this.
RE: Toggles for Sub-Totals and Grand-Totals on Matrixes
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.
RE: Toggles for Sub-Totals and Grand-Totals on Matrixes
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