4 Replies Latest reply on Jan 18, 2017 5:31 AM by Jim Dehner

    Bucket based on Ranking

    Sat P

      Have requirement to Rank customer based on their Sales amount and then bucket Top customers.

      The data is based on Region, Customer and Sales. The final output/report will not have Customer

       

      I was able to do it based on Region and Sales Amount, however cannot rank as for ranking need Customer

       

      Any suggestions/thought to achieve this.

       

      Report output


       

      Row LabelsSum of Sales
      America376
      Top 5312
      'Other64
      Europe427
      Top 5303
      'Other124
      Grand Total803

       

      DATA

       

         

      RegionCustomerSales
      AmericaA398
      AmericaB389
      AmericaC155
      AmericaB245
      AmericaA225
      AmericaC224
      AmericaB116
      AmericaA110
      AmericaD19
      AmericaD25
      EuropeE289
      EuropeE166
      EuropeB265
      EuropeB143
      EuropeC140
      EuropeC232
      EuropeE330
      EuropeB327
      EuropeG120
      EuropeG215