hi Rahul,

So one way to do this is using LoDs...I created the following LoD calculation to work out the difference in profit from one year to the next (btw I've used MAX Year and MAX Year -1, with the Year Filter as context, so it will work with any 2 years selected)

[Profit +/-]

{FIXED [Sub-Category]: SUM(IIF([Order Date Year] = {MAX([Order Date Year])},[Profit],NULL))}

-

{FIXED [Sub-Category]: SUM(IIF([Order Date Year] = {MAX([Order Date Year])}-1,[Profit],NULL))}

I then bring this onto colour and set up as...

For my own indulgence I also added Year to size to get that extra feeling of direction!

There is also a way with Table Calcs, but it's more complicated (although less "hard coded")

Hope that helps

Simon was faster.

Or just one path.

And don't forget to change the filters to "context".

Thanks,

Shin

Hi Rahul

Don't worry.

Both Simon and I were lazy to skip the step by step formula creation, because we already knew answer for typical questions.

Actually the formula is long, but not so much "complex".

I hope you can break down the formula to 4 or more and you understand the steps/logic better.

Thanks,

Shin

Rahul,

Good job.

It definitely works in this specific case.

Ours(LOD) will cover the case when you have 3 or more years and want to filter it to two.

Thanks,

Shin