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
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.
No "if", could I use the AGGR function to get the full total?
Please share sample application or data in excel file.
Retrieving data ...