Result Total - Pivot Table

[#1]

Dear,

Good afternoon, would be so kind to help me with the following problem.

The totals presented not match the average of the values. Example in the designated column should appear which is the average 33.1 (Pivot Table). I would suggest that you can do or how I can fix it. Attached Excel table.

In advance my sincere thanks.

Regards

Mauro

[sunny_talwar]

Try this:

=Sum(Aggr(YourCurrentExpression, AllDimensionsInTheTable))

=Avg(Aggr(YourCurrentExpression, AllDimensionsInTheTable))