Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I need your support, I want to use the set analisys. in my graphics I need to add the sales according to the selected year; but if the year is not selected, add the sales of the maximum date.
how can I do it
I am using
sum ({<[Year] = {'$ (= year (max (Date)))'}>} Sales) but when you want to select two years in my filter, you do not add them to me.
hic
May be this -
if(getselectedcount(Year)=0,
sum ({<[Year] = {'$ (= year (max (Date)))'}>} Sales),
sum(Sales)
)
Thanks for your support, his answer helped me a lot.