4 Replies Latest reply on Sep 29, 2014 8:07 AM by Heather Roth

    Using Index to Rank

    Joe Knight

      Hello,

       

      I want to create a dynamic worksheet that shows the top 5 customers by sales.  The catch is that I want to lump the remaining customers into a single bucket to compute % of total across the entire population in my table.  I want the user to be able to filter by region, and month so I don't want to add a flag in the back end.  Essentially, the data in the workbook should look something like this.

       

      CustomerRankSales% of Total
      a110017.2%
      b29917.0%
      c39015.5%
      d48815.1%
      e58514.6%
      Rest of cust populationn/a12020.6%
      Totaln/a582100.0%

       

      I am using confidential data so I can't post a packaged workbook.  In the example above I have 50 customers.

       

      Any help would be greatly appreciated.

       

      Joe K.