Hello everyone,
I'm looking for a method to visualize the difference between two years in a pivot table.
This is what I would like to get:
I tried this formula:
Sum( { $<[DocumentYear]={$(=max(DocumentYear))}>} Revenue)
- Sum( { $<[DocumentYear]={$(=max(DocumentYear)-1)}>} Revenue)
This is what I get:
I guess each column filters the data for the choosen year and it is not possible to use the formula for my case.
Do you know a method for my case?
Thank you in advance!