How can write set analysis expression which analysis sales for sales up to this year and sales up to this point last year?

[jblomqvist]

Hello,

How can write set analysis expression which analysis sales for sales up to this year and sales up to this point last year?

I have two fields, OrderDate which has all the dates for all the years (including this year and last year)

and my Sales field has the sales values.

How can I write set analysis which analyses like for like sales this year and last year.

It will be a Line Chart with the Dimension as Month (which is coming from the OrderDate field)

[giakoum · Accepted solution]

Set Analysis for Rolling Periods