Hello Community
I have been trying to compare each month's value to the value in December of last year but couldn't find a way to populate the 2021 Dec_profit to each row in 2022 in order to compare it.
I have attached a workbook and I want to achieve the following:
- the expected result's value should be shown as the value in December of last year
- The difference column should be the difference between the Expected result and the profit
is there a way to achieve this? Any help would be greatly appreciated!
4 answers

As you see LOOKUP function cannot get values outside filters.
How about this instead?
Keep [date_range] having last 25 month.
Add new calculation and filter it TRUE only.