Average of weighted average

[james227]

I am trying to calculate an average across all dimensions of a calculated weighted average.

Let's use the below pivot table as an example.

I have 4 dimensions: year, units (20,30,50), dimension1 (a,b) and dimension2(1,2,3)

First I'd want to calculate the weighted average based off of the units.  I used an expression:

=(SUM(Units)/(SUM(TOTALUnits)))*value

That gives me:

That part that I am stuck on is how do I get the averages of the new weighted values above but using less dimensions?

Final results I want to see are:

Thanks

[sunny_talwar · Accepted solution]

May be this

Avg(Aggr((SUM(Units)/(SUM(TOTALUnits)))*value, dimension1, dimension2, year, units))