Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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!!

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

3 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

Not applicable
Author

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
Luminary Alumni
Luminary Alumni

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

Cheers,

Jason