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!
