Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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.
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
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.
Please mark your own answer as correct so the thread looks answered.
Cheers,
Jason