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 (8)
RE: Toggles for Sub-Totals and Grand-Totals on Matrixes
It would be very nice to be able to have subtotals without grand totals, I've got matrices that are multi-year sets of data where a subtotal row that sums a single year's values is perfect but a grand total row summing all the years does not. Grand Total needs an on-off toggle separate of the subtotals.
RE: Toggles for Sub-Totals and Grand-Totals on Matrixes
Seriously, this is something that needs to be solved. When using several columns (like months) and more than one field in the row axis, there should be an option where I don't want row subtotals but, of course, I want a grand total at the end for every column. This is a basic feature in pivot tables in Excel and has been around since....wait for it....1995.
Please, give it a thought will you?
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