2 Replies Latest reply on Jul 12, 2018 12:36 AM by ALOK KUMAR SACHAN

    How to Color the particular measure column by condition

    san p

      Hi Team,

       

      Please help me on below issue,

       

      I was trying to color  only Sales column , to achieve this , i have created calculation filed "margin" to highlight the sales column values according to margin condition as shown in below screenshot.

      and after dragging the "margin%"  calculated field  to marks -> color.

      look like this calculated field color is applied to all three columns in the worksheet

       

      But i need to apply only for  "Sales" column .

       

       

      Could anyone please suggest me , how to color only sales column,
      and i do not want to make as discrete for Profit , Discount columns because in this case i will not get grand total for discrete columns

       

       

       

       

      Regards,

      San Pawar