9 Replies Latest reply: Mar 24, 2017 4:53 AM by Sunny Talwar RSS

    Sales range as calculated dimension

    Simon Hung

      Hi,

       

      Does anyone know how to make a bar chart that count the number of salesperson by sales-range as calculated dimension?  Thanks.

       

       

      SalespersonSales in Mar
      A300
      A1500
      B900
      B300
      C200
      C300

       

      Expected result

      Sales < 1000 :  1 salesperson (C)

      Sales > 1000 and < 2000 :  2 salesperson (A & B)