Aggr average not rolling up as expected in pivot table

[Brysonds]

Hello,

I have a pivot table with several dimensions, and am trying to display the average at each level of the dimension below. I am trying to avoid using any hard-coded expression based on dimensionality() or getobjectfield() since there are several dimensions and they may be moved around for analysis.

Simplified example and expected output:

This is the formula I am using:

Avg(Aggr(Sum([Measure]),[Customer Group],[Customer],[Employee],[Product]))

Interestingly enough, if I add a second measure of Avg(Measure), this gives the exact same output as the aggr version above, so I assume there is a problem with my expression.

[vinieme12]

don't use Avg() at all, calculate the average  as sum() / count()

example, Average sales per transaction

sum(Sales)/Count(Transaction)