Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Selected year sales is :
Sum({< Year={$(=max(Year))}>}QTY_KG)
returns the right values , works fine.
While last year sales is :
Sum({<Year= {$(=max(year)-1)}>}QTY_KG)/1000
It only displays the current year QTY_KG !
Both lines return the same values !
How can I fix that ? What's wrong with the syntax ?
Check the Year and year.
Check if you use selections or dimension in table like year-month
Tried year and Year . the same.
I don't use dimensions in table like year month, just customer name.
What do you mean if I use selections ? Year is selected (happens with every year I select).