5 Replies Latest reply: Apr 2, 2017 9:22 PM by Sunny Talwar RSS

    Creating buckets based on turnover

    Paul Schmidt

      Hi All

       

      I have the following calculated dimension for Customer Rank:

       

      =If(Aggr(Rank(Sum([Turnover])),[Customer ID])<=10,dual('Top 10',1),dual('Other',2))

       

      Now I would like to create another calculated dimension for Turnover Rank, the buckets are based on:

       

      - 50k+

      - 30k to 50+

      - 20k to 30k

      - 10k to 20k

      - 5k to 10k

      - 1k to 5k

      - <1k

       

      hic how would I re-engineer the Customer Rank into a Turnover Rank.

       

      Thanks, Paul