Skip to main content
martin cheng 님이 #Tableau Desktop & Web Authoring에 질문했습니다

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개
  1. 2022년 5월 26일 오전 4:09

    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