Pivot Table has incorrect Total

[Anonymous]

Hi, I have a pivot table that is displaying the incorrect total. in a straight table, it is displaying as below:

but in a pivot, it shows up like this

any ideas?

[pedrolyra]

What is the expression you are using?

If you are using "if" in the expression, try to change your "Total Format" in expression setting from Automatic to Sum.

[isingh30]

Please share sample application or data in excel file.

Thank you!

[Anonymous]

No "if", could I use the AGGR function to get the full total?