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