Show Next Level and Expand Level not updating totals

[MPS006385581]

When I Expand to Next Level or Show Next Level, it wil not update any totals on my matrix.  However, doing a drilthrough will update.  Anyone able to provide a solution to show totals updating when either expanding or showing next level?

[v-sihou-msft · Accepted solution]

@MPS006385581

In matrix, unless you select Drill down mode, otherwise the grand total will never change when expanding or show next level. This is default behavior.

[MPS006385581]

In a matrix when I dirll through the totals update.  HOwever, if I either Expand to next level or Show next level, the totals will not update.  Is there anyway I can show the totals to update as I Show or esxpand to next level.

[MPS006385581]

When I either do Expand next level or Show level my totals are not updating like they do on Drill Down.  Can anyone help me to hav eit so it does update and not stay at the top level,