topic next row in pivot table in App Development

next row in pivot table

Femke_DPG — Tue, 13 Jun 2023 08:58:22 GMT

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 — Tue, 13 Jun 2023 18:16:48 GMT

Try this

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

Femke_DPG — Wed, 14 Jun 2023 05:09:21 GMT

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

marcus_sommer — Wed, 14 Jun 2023 06:18:33 GMT

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