next row in pivot table

[Femke_DPG]

Hi all, 

I need to check each row (so each date) within one channel (DAB) for the SOFT name. 

The name of 05/06 has to be different from the name of 06/06, 06/06 has to be different from 07/06, ... 

I need to identify the next row in the pivot table to compare 2 rows. 

Can anyone help me? 

Thx

[Chanty4u]

Try this

if(Channel = 'DAB', Above(Date) & '-' & Above([SOFT Name]), '')

[Femke_DPG]

Thanks, but with this solution it shows the PREVIOUS date and not the NEXT line: 

[marcus_sommer · Accepted solution]

To look in the opposite direction you could use below() instead of above().