Wrong Percentage TOTAL on pivot table

[micheledenardi]

Dear All,

I'm working with pivot table and percentages.

As you can see from below screenshot the "total" percentage is correct on straight table (150%) but not on pivot table(829,17%).

How to fix pivot table totals ? I need 150% total also on pivot table.

Attached you can find also the QVF.

[anseglko]

The 829,17 seems to be the sum of those percentages. Can you switch it to average?

[micheledenardi]

Already tried, not working. 

[micheledenardi · Accepted solution]

Sum(Mea1)/Sum(Mea2)