Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I have a variable that calculates the rate of something for a period of time (Previous 13 Weeks):
=Sum({<PRE_POST_WEEKS={[>-13 <0]}>}SALES_VOLUME) / Sum({<PRE_POST_WEEKS={[>-13 <0]}>} CALLS_VOLUME)
Problem is that I need to calculate this 'constant' for each for each SALES_PERSON, so each person has an assign constant in other calculations of my app.
Currently, the variable will assign the same generic constant to all the persons and only when I filter down to one Person I get the right rate.
Example
Currently: Ideally:
Variable | Person Variable | Person
0.9 A 0.9 A
0.9 B 0.7 B
0.9 C 0.4 C
Any Ideas?
Hi Marcel,
To aggregate to a certain level try using aggr -function:
=Aggr(Sum({<PRE_POST_WEEKS={[>-13 <0]}>}SALES_VOLUME) / Sum({<PRE_POST_WEEKS={[>-13 <0]}>} CALLS_VOLUME), Person)
Hi Marcel,
To aggregate to a certain level try using aggr -function:
=Aggr(Sum({<PRE_POST_WEEKS={[>-13 <0]}>}SALES_VOLUME) / Sum({<PRE_POST_WEEKS={[>-13 <0]}>} CALLS_VOLUME), Person)