0 Replies Latest reply: Nov 7, 2016 5:55 AM by Yogita Mehta RSS

    selection

    Yogita Mehta

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