Comparison previous year in case date is a dimension

[#1]

I have a problem, i would like to have situation 2 as result, by using a set expression. but for some reason i'm not able to do this.

Is this possible to get S2 with set analysis ?

So far the only solution i can image is loading the dataset twice and once with year+1 as year and costumers as costumers LY and once with year as year and costumers as costumers CY and then join both dataset on the year field.

But due to the large dataset it aint possible, so i wonder wether it is possible using set analysis

[sunny_talwar · Accepted solution]

You can use Above()/Below() functions to do this

Missing Manual - Above() and Below()

Below([CostUmers CY])