Notifications
Clear all
Xtreme Pivot Tables
2
Posts
2
Users
0
Reactions
21
Views
Topic starter
I'd like to have a weighted average computation in addition to the usual average one. Is there a way to do that via the calculated field or item functionality? in other words, an average of field A using the values in field B as weights.
Posted : 09/03/2021 11:33 am
Hey Edward,
Unfortunately this cannot be created inside a Calculated Field or Item, as its limited what formulas it can perform.
What you can do is create a helper column in your data to multiply SALES x UNITS (as an example).
You can put this new Field in the Pivot Table values area.
Then you can also drop the UNITS field in the values area.
Then finally, you cam create a formula using GETPIVOTDATA or a manual formula outside the Pivot Table.
I hope this workaround helps.
Thanks,
John
Posted : 10/03/2021 1:21 pm
