Max week or max week minus number as dimension?

[wiz_nerd]

I have Week-year, week and year field I want to use in calculated dimension in two ways.

1 to get the max week and max year and second to get max week -n week and max year.

My Table Looks like this:

Week-year	Week	Year	Value
52-2020	52	2020	1
52-2020	52	2020	2
51-2020	51	2020	3
42-2020	42	2020	4
52-2019	52	2019	5
52-2019	52	2019	6
51-2019	51	2019	7
42-2019	42	2019	8

Output 1:

Week-year	Week	Year	Value
52-2020	52	2020	1
52-2020	52	2020	2

Output 2(Max week minus Nweek):

Week-year	Week	Year	Value
51-2020	51	2020	3

[wiz_nerd · Accepted solution]

=(Max(TOTAL {<field_Year= {'2020'}>}Field_Week))-6