YoY Difference and Growth

[Anonymous]

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!