set analisys

[denisetrujillo]

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‌

[Digvijay_Singh]

May be this -

if(getselectedcount(Year)=0,

     sum ({<[Year] = {'$ (= year (max (Date)))'}>} Sales),

     sum(Sales)

)

[denisetrujillo]

Thanks for your support, his answer helped me a lot.