YoY Difference and Growth

[Anonymous]

Hello everyone,

I'm looking for a method to visualize the YoY difference and growth in a pivot table.

For example:

I tried this formula:

Sum( { $< [DocumentYear]={$(=max(DocumentYear))}>}  Revenue)

- Sum( { $< [DocumentYear]={$(=max(DocumentYear)-1)}>}  Revenue)

But I don't get what I want:

I think the problem is, that the pivot table filters the data for the years.

Do you know a method for this problem?

Thank you in advance!

[isingh30]

Please share your data in excel sheet or sample application.

Thank you!

[Anonymous · Accepted solution]

Hey Ishtdeep Singh,

thank you for your answer.

I already have found a solution for my problem. I used 'Before()'.

Sum( { $< [DocumentYear]={$(=max(DocumentYear))}>}  Revenue)

- Before(Sum( { $< [DocumentYear]={$(=max(DocumentYear))}>}  Revenue))