Total Amount Incorrect

[upaliwije]

I have in qv Document the following pivot table.

In the Difference the total shown is incorrect. It may be probably due to incorrect expression. pls look into this in my attached QV document and advise me to correct it

[Kushal_Chawda]

what is expected output?

[upaliwije]

Thank you very much Sir, You have always helped me with valuable guidance. Still I am unable understand how the Aggr function works. Kindly elaborate it to me or provide me with information  of blogs/books on the subject

Thanks

[sunny_talwar]

Without the Sum(Aggr(....)) the total rows is also evaluated for the If condition, but by using Sum(Aggr(....)), you can telling your chart to show the sum of rows as the total instead of using the if condition for the total row.

Does that make sense?

[upaliwije]

Yes Thanks a lot