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
