Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use something like below...
='Jan - '&SubField('$(MonthNames)', ';', $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today())))))
What is the requirement? Unable to understand from your question..
Use something like below...
='Jan - '&SubField('$(MonthNames)', ';', $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today())))))
Wow you are very good., it work again.