Compare the CY Sales and PY Sales by Country in one table. Year and month selection should not be affects the data

[Ramak]

Hi

Can you please help with the syntax for 

Compare the CY Sales and PY Sales by Country in one table. Year and month selection should not be affects the data ?

I used the below syntax but it is not working

sum({<Year={"$(=Max(Year))"},Year=,Month=>}Sales)  for current year sales

can you please help 🙂

[sasikanth]

Try below 

CY:

sum({<Year={"$(=Max({1}Year))"}, Month=>}Sales) 

PY:

sum({<Year={"$(=Max({1}Year)-1)"}, Month=>}Sales)