Aggr average not rolling up as expected in pivot table

Brysonds — Wed, 27 Apr 2022 15:04:29 GMT

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.

Re: Aggr average not rolling up as expected in pivot table

vinieme12 — Thu, 28 Apr 2022 17:00:29 GMT

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

example, Average sales per transaction

sum(Sales)/Count(Transaction)

topic Aggr average not rolling up as expected in pivot table in App Development

Aggr average not rolling up as expected in pivot table

Re: Aggr average not rolling up as expected in pivot table