Forum Discussion
EdgarEngieImpact
Jun 21, 2022Copper Contributor
Pivot Table - Average of average
Hello, I am creating a pivot table with averages, but I am getting the wrong numbers because the pivot table is making the average of an average. Anyone knows if there's a way to solve this? ...
SergeiBaklan
Jun 21, 2022Diamond Contributor
Perhaps like this
with
Avr Clicks/Open:=DIVIDE( SUM( Table1[Clicks] ), SUM( Table1[Opens] ), 0 )