3 Replies Latest reply: Jul 4, 2016 10:00 AM by PAUL YEO RSS

    Label expression NO display Jan - Dec when user click month = 12

    PAUL YEO

      Hi All

       

       

      Below is my Expression label work fine :-

      ='Jan -  ' & date(makedate(max(year)-0,max({<Year={$(=max(year)-0)}, sales = {'*'}>} Month)), 'MMM-YYYY') & ' ' & ''  &ColumnDim51& ' ' 

       

       

      Recently MrManish help me to modify the expression , allow user to view sales till Dec. when use click on month=12 yr=2016 , the label display not correct.

       

       

      Hope some one can share with me.

       

       

      Paul