6 Replies Latest reply on Jun 28, 2016 2:27 PM by Mia Lee

    Different Cap by Dimension

    Mia Lee

      Hi, all_


      I am trying to set a different cap by the dimension value. As shown/attached, all profit cap is set at 35% - meaning, if the profit is above 35% will be marked as 35%, below -35%  will be marked as -35%.

      However I'd like to have a different cap for banana - if the profit is over 30%, then mark as 30%, below -30% then mark it as -30%.

      So in below case, Cap(calculated field) should show 35% for apple and peach 30% for banana.

      Does anyone have a good idea to implement different range set for different dimension value? (for aggregated calc)


      Thank you for your help in advance!