5 Replies Latest reply: Jul 3, 2012 9:05 AM by Scott Springer RSS

    Determine Users to Get to 80%

    Scott Springer

      How do I determine how many Users it takes to reach 80% of sales?

       

      For example, I have 5 users (very simple example):

      UserName, Sales

      Scott, 25

      Jack, 15

      Sally, 20

      Bob, 10

      Nancy, 5

       

      How do I sort high to low by spend and then determine that my top 3 users make up >=80%?  The answer I want to achieve is "3".

       

      Thanks