Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Or maybe
=Sum(TOTAL<District,Month> aggr(1 ,District, Month,Position))
try this
sum(TOTAL aggr(Count(DISTINCT Position),District, Month, Position))
Or maybe
=Sum(TOTAL<District,Month> aggr(1 ,District, Month,Position))
Thanks a lot, that was quick!
How are you not an MVP stefan