topic set analisys in Management & Governance

set analisys

denisetrujillo — Fri, 06 Apr 2018 22:28:25 GMT

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‌

Re: set analisys

Digvijay_Singh — Fri, 06 Apr 2018 22:49:10 GMT

May be this -

if(getselectedcount(Year)=0,

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

sum(Sales)

)

Re: set analisys

denisetrujillo — Mon, 09 Apr 2018 14:09:08 GMT

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