8 Replies Latest reply on Mar 13, 2017 7:52 AM by Pauline Le Corvec

    How to display the range for measure and highlight the dimensions

    Srikar N

      Hello Team,

       

      My worksheet has 2 columns Segment and Profit. I created a calculated column 'Profit %' to find the % of profit.

      Now my requirement #1: Display the Range of Measure

      1. Please refer the column 'Profit % Range' below, that needs to be calculated based on the column  'Profit %'.

       

      I created a new column 'Profit % Range' with the condition below, its not working for me as it shows me the below result.

       

           if ([Profit %]>=0 and [Profit %]<30) then '0-30%'

           elseif ([Profit %]>=30 and [Profit %]<40) then '30-40%'

           else '>=40%'

           end

       

       

      Requirement#2: Highlight the dimension ONLY

      How to highlight the dimension 'Segment'  as below. Please note that I dont want to highlight any other columns 'Profit % Range' and 'Profit%'. I just want to highlight dimension ONLY.

       

      Please provide your inputs on this. Thanks in advance.

       

      Thanks,

      Srikar

                            

      SegmentProfit % RangeProfit %
      Consumer>=4047%
      Corporate30-4032%
      Home Office0-3021%