2 Replies Latest reply: Jun 21, 2014 1:52 PM by Venugopal Orugonda RSS

    before

      Dear all,

       

      i have a pivottbale and i want to use this as dimension but it does not seem to work.

      Anybody that can help me out how to correct this?

       

      ReferencePhase
      125457Z03
      125457Z05
      199125Z02
      199125Z02
      301547Z01
      455124Z01

       

      Reference is sorted and is a dimension in my pivot table

       

      Now i want to highlight or only show the lines with following criteria

       

      reference=above(reference) and phase<>above(phase)

       

       

      At the moment i tried

      =if([3rdPartyRef]=before([3rdPartyRef]),
                
      if([3rdPartyName]<>before([3rdPartyName]),
                      1,
                     
      null()
                )
      )

      But this gives me //error in calculation