Hi,
I have 1 button and 2 filters. Based on the selection on these, my chart should show data
I have default selection on Year=2018
I have requirement like if
(1) OFF & month: OFF is selected from button and any 1 or more values selected from 'month' then it should show sum(A)
(2) OFF & year: OFF is selected from button and no value from 'month' is selected, then it should show sum(B)
(3) ON & month: ON is selected from button and any 1 or more values selected from 'month' then it should show sum(C)
(4) ON & year: ON is selected from button and no value from 'month' is selected, then it should show sum(D)
To achieve this, I used this below expression
if(GetSelectedCount(month)>0,
if(vOFFON=0,sum(A),sum(C)),
if(vOFFON=0,sum(B),sum(D)))
But it is running for long time and finally displays 'Calculation Timed Out'. i need an alternate expression for this
For test purpose, when i tried with either "if(vOFFON=0,sum(A),sum(C))" or if(vOFFON=0,sum(B),sum(D))
it is responding in fraction of seconds.
But when i combine all conditions with the help of Getselectedcount, it is not responding
Please help me
Regards
Krishna