Toggles for Sub-Totals and Grand-Totals on Matrixes

[abeer1]

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.

[fbcideas_migusr]

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

[kciesli]

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.

[info80]

A similar thread with 120 votes also exists for this.

[pbiideas1]

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

[marcos_joseph]

Hi, take a look at this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18346846-show-not-show-subtotals

[alfi_sahri]

I voted. How many vote required before this idea included in the next updates?

[fbcideas_migusr]

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?

[wcarter2]

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.