5 Replies Latest reply: May 2, 2014 2:00 AM by Manish Kachhia RSS

    How to class the results of aggregation?

      For example, I have a table that looks like this:

       

      DateSales PersonSales
      1/4/2014Thomas3
      2/4/2014Mike2
      2/4/2014Adam1
      2/4/2014Thomas2
      3/4/2014Mike1
      3/4/2014Kate5
      4/4/2014Adam2
      4/4/2014Thomas5

       

      I would like to classify the sales person based on their total sales performance, i.e.

       

      Sales Performance ClassNumber of Sales PersonsTotal Sales
      <526
      5 - 915
      >=10110

       

      What formula should I use as the dimension for the classification?

      I have tried =class(aggr(distinct sum(Sales),SalesPerson),5) but it does not work, nothing came up.