5 Replies Latest reply on Feb 4, 2019 7:37 AM by Timothy Manning

    Conditional formatting of measure & different measures in same cell

    Dolev A

      Hey

       

      I've got 2 separate unanswered questions, hope you could help me out

       

      1. Conditional formatting of a measure

       

      How can i create a measure that changes it's color dynamically with a given condition?

      For example, lets say this is my table:

       

       

      CountryROISpend
      GER120%400
      FRA130%10
      USA170%300
      CAN50%200

       

      I would like to create a condition to the ROI measure only that changes the values colors. For example, IF ROI>140% THEN 'Green' ELSE 'Red' END. (something like that)

       

       

       

      2. I wonder if there is any way to show 2 different measures in one cell. for example in the table above, spend and % of total, in the same cell. It should look like that:

       

       

      CountryROISpendMyWish
      GER120%400400 , 44%
      FRA130%1010 , 1%
      USA170%300300, 33%
      CAN50%200200 , 22%

       

      (400 is 44% of the total column, 10 is 1% etc.)

       

      Hope my questions are clear,

      Thanks a lot !