Wrong Total in a Pivote Table, Why????

[#1]

Hi Guys, I just don´t understand why my totals in this pivote table is wrong, please does any body have any idea???

I attached the app, Thank you Guys!!

[Jason_Michaelides]

This is a classic issue and is to do with your use of Avg().  The "Total" is not a sum of all the other totals but the average across all dimension values.  With an average this will most likely be different.  In the attached file I have copied the pivot table as a straight table for you and added the same expression, but this time selected "Sum of rows" for the total (you can't do this in a pivot table).

Hope this explains it!

Jason

[#3 · Accepted solution]

Hi Jason, Thanks foe your Reply, I found the solution, we can do it using set analisys, I attached the app.

Thank you I appreciate your time and reply.

BG.

[Jason_Michaelides]

Please mark your own answer as correct so the thread looks answered.

Cheers,

Jason