Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Please share sample application or data in excel file.
Thank you!
No "if", could I use the AGGR function to get the full total?