Total not accurately reflecting in pivot table

[#1]

Hi all,

I have a pivot table with a calculated dimension to only show certain important variables (an if(match) and then manual selected variables. This has worked however, the pivot table now shows totals including the values that I have hidden. Is there any way I can adjust these totals to just show the values I selected.

Thanks

[sunny_talwar]

May be try using Sum(Aggr()) function to fix the totals

Sum(Aggr(YourExpression, YourChartDimensions))

[#3]

Thanks Sunny, I've tried that and it gives me the correct number but I can't reflect it as the bolded total at the bottom of the table.

[sunny_talwar]

Can you share an image of what you are seeing?

[#5]

Below is what it shows normally when I don't have the selections in the box to the left.

Here is what I want the totals to show:

The ones selected are the only ones in the box because I hid the others ones

[sunny_talwar]

I think you need to check 'Suppress When Value Is Null' on the dimensions tab. See if that fixes your issue....

[#7]

That did it. Thank you very much!!