Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
Try below
CY:
sum({<Year={"$(=Max({1}Year))"}, Month=>}Sales)
PY:
sum({<Year={"$(=Max({1}Year)-1)"}, Month=>}Sales)