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 :

      ScenarioProductMeasure
      ReferenceA12
      ReferenceB20
      ReferenceC15
      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 ?

       

      Regards