Skip to main content

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:

  1. the expected result's value should be shown as the value in December of last year
  2. 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
  1. May 26, 2022, 4:09 AM

    As you see LOOKUP function cannot get values outside filters.

    How about this instead?

     

    Keep [date_range] having last 25 month.

    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. 

    Add new calculation and filter it TRUE only.

    image

0/9000