3 Replies Latest reply: Aug 15, 2013 8:55 AM by Steve Zagzebski

# Set Analysis - Thresholds

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%?

• ###### Re: Set Analysis - Thresholds

The only way I know of is to do some calculations in the script first. See attached example.

• ###### Re: Set Analysis - Thresholds

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..

• ###### Re: Set Analysis - Thresholds

I have never used fractile - but is there any way to incorporate that?