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

[paulyeo11]

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

[MK_QSL]

What is the requirement? Unable to understand from your question..

[MK_QSL · Accepted solution]

Use something like below...

='Jan - '&SubField('$(MonthNames)', ';',  $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today())))))

[paulyeo11]

Wow you are very good., it work again.