5 Replies Latest reply: Feb 11, 2014 9:08 AM by Erica Whalley RSS

    Pivot table - Highlight data based on previous rows (multiple dimension)

      Hello all,


      I'm trying to format a pivot table based on previous/above rows.


      Let says I have this table :

      Scenario 1A10
      Scenario 1B21
      Scenario 1C15


      I would like to compare the measure value of products in both scenario.

      In the above example, only product A and B should be highlighted because their value changed between both scenario.


      I tryed something like this but it doesn't work :


      if(Scenario<> 'Reference',

        if(SUM( {1 <Scenario={'Reference'}>} Measure) <> SUM( {1 <Scenario={'Scenario 1'}>} Measure), green(100))




      Any idea ?