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

    Set Analysis - Thresholds

    Steve Zagzebski

      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:

       

      SalespersonClientSales
      SueA35
      SueB55
      SueC75
      SueD70
      SueE80
      DaveF20
      DaveG60
      DaveH100
      DaveI140
      DaveJ180

       

      RESULTING OBJECT:

      80% Sale Threshold# of Clients making up 80%
      Sue2254
      Dave4203

       

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