LFL-analysis (showing data in table)

[oleksii_pohibsa]

Hello.

I need to make LFL-analysis for some measures compared with previous year, month, week or another period.

I did that using set analysis and it works

But now I need to show these data in table.

Sales (LFL) 2021 show data of Sales 2020...

2022-Q2 Sales (LFL) = Sales 2022 Q1

I can't realised this(

[G3S]

does getting the sales period's year  and reducing that by 1 work? might have to be set analysis