before

[#1]

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?

Reference	Phase
125457	Z03
125457	Z05
199125	Z02
199125	Z02
301547	Z01
455124	Z01

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

[upaliwije]

Not Working

[#3]

Hi,

Check my app.