Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
This feels like something that should be straight forward, but I'm hitting a brick wall!
I have a pivot table. I have a dimension which is a date. I have an expression which gives me a count of something (so my result is a count of something across date) - all good.
So let's assume my pivot table looks like the below;
01/08/2022 02/08/2022 03/08/2022 04/08/2022
100 200 250 150
I want to show the daily movements on a new row as;
- 100 150 -100
I thought that there would be a simple way to do this in expression?!
Any help appreciated!
Thanks all 🙂
@DataKnight1 Explain the logic behind your output.