Hello,
I have 2 List box Year & Month.
When user clicks on multiple months it gives me minimum month (April's Open count) perfectly.
But when user selects mutiple YEARS from the listbox its not working for other Years.
When user selects mutiple years ,I want minimum year's count as April month of both the Years. Set Analysis as below.
Set Analysis:
= if
(
GetCurrentField("Year-Month") = 'MONTHS',Sum ( OPEN_COUNT)
,if(GetCurrentField("Year-Month") = 'YEARQTR' ,Sum({<[MONTH_FORSELECTION] = {'JAN','APR','JUL','OCT'}>} OPEN_COUNT)
//, if(GetCurrentField("Year-Month") = 'YEARS',Sum({<[MONTH_FORSELECTION] = {'APR'}>} OPEN_COUNT))
, if(GetCurrentField("Year-Month") = 'YEARS',Sum({<YEARMONTHDATE = {'$(=MIN(YEARMONTHDATE))'}>} OPEN_COUNT))
),
)
Thanks in advance.
Bhavesh