my filter is a conditional filter if (NO=('Ba'),Month_Year)
Month year formay jan-2014.
my expression is
count({<NO={'Ba'},STATUS={'OPEN'},
Year={$(=max(Year))}
,[Calender MONTH]={$(=max([Calender MONTH]))},
[work_DATE] = {$(=Date(Max( {< NO={'Ba'}>} [workDATE])-1, 'DD/MM/YYYY'))SEQ_NO)
By defualt need to show latest month data , if i selcta nt thing from Month year (conditional filter) then is should show 'NA' for other months,.