Issue with count formula

[#1]

Dear colleagues,

I am trying to achieve allocation of total territory's sales among of representatives that are covering it. For example, I have 3 representatives A1, A2, A2 on a terriotry A and sales are equal to 10. If I just drop position as dimension, I get total territory sales across each position:

To fix that, I want to count number of positions covering this territory and divide total territory sales by number of positions. For that I tried below formula: =max(aggr(Count(DISTINCT Position),District, Month)), it works well only for the first position, the remaining positions are supressed:

Could you please help to understand why I am not able to achieve the desired result?

Many thanks in advance.

P.S. I am also attaching QV sample file.

[#2]

try this

sum(TOTAL aggr(Count(DISTINCT Position),District, Month, Position))

[swuehl · Accepted solution]

Or maybe

=Sum(TOTAL<District,Month> aggr(1 ,District, Month,Position))

[#4]

Thanks a lot, that was quick!

[#5]

How are you not an MVP stefan