I’m here again asking for help.
This time I’m trying to create a table to show a trend with a simple green/red arrow. This trend has to be calculated out of a comparison between the data on that current row vs the one on top of it.
I would like it to be:
Trend on first row: empty
Trend on second row: red
Trend on third row: green
Trend on fourth row: green
All this has to be dependent on what’s currently there in the table. But I have no clue on how to build a measure like that (or if it’s possible at all)