selection

[yogitamehta10]

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,.