Forum Discussion
How to Avoid Averages of Averages in Pivot Table
I'm creating a pivot table to compare different advertisement types for pay-per-click campaigns. The problem I am experiencing is that the "sum" or "header" value is calculating the average for the s...
Hi hfoster
The old way (and simplest on the face of it) is to add a calculated Field
More Advanced Option
If you often need calculations in Pivot Tables then these days the alternative is to load your data to the Data Model when creating the Pivot Table
And then write a DAX formula (called a measure) by right clicking on the table
Hope that helps
Wyn
MVP
Australia (UTC + 😎😎
If this answer was the best solution please click the button
I also happily accept likes 😀