Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I don't even know if this is possible. I need to find how much makes up the top 80% in sales and the count of how many clients by sales person:
Salesperson | Client | Sales |
Sue | A | 35 |
Sue | B | 55 |
Sue | C | 75 |
Sue | D | 70 |
Sue | E | 80 |
Dave | F | 20 |
Dave | G | 60 |
Dave | H | 100 |
Dave | I | 140 |
Dave | J | 180 |
RESULTING OBJECT:
80% Sale Threshold | # of Clients making up 80% | |
Sue | 225 | 4 |
Dave | 420 | 3 |
For Sue Client's E,D,C,and B are her top clients-making up 80% of her sales
for Dave clients J, I, and H are his top clients making up 80% of his sales
Is it possible to write set analysis that would add up what80% of salespersons business is and how many client made up that 80%?
The only way I know of is to do some calculations in the script first. See attached example.
The only way I know of is to do some calculations in the script first. See attached example.
Thanks! Good to know I need not spend alot of time trying to figure out some set analysis.
One quick follow up - if I added the extra complexity of trying to compare the clients (that made the upper 80%) to that clients prior year amount is that even possible? (for example in the example above if I selected on 80% I would want Sues clients (for example) E,D,C, and B for the prior year). Or am I asking for a nightmare..
I have never used fractile - but is there any way to incorporate that?