11 Replies Latest reply on Jul 1, 2011 3:47 PM by 871928

    New Calculated Item with Conditional Format

    Alex1
      Hi friends!

      My question is simple. Is possible to apply conditional format in a calculated item that I have created in a pivot table?
      Only I want to apply conditional format in my calculated item

      On my example I have
      --------------------year1------year2----dif(my calculated item)
      measure1-------100-------50---------50
      measure2-------75-------100---------(-25)

      I want if my dif is >0 green colour and if <0 colour red but only in my dif column, if I put this in my measure (criteria tab) works but I have all values in green or red depends my condition...

      Thank you!