Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below expression , it will display Jan to Mar 2016 when i click on year = 2016 and month =3 :-
='Jan - ' & date(makedate(max(year)-0,max({<Year={$(=max(year)-0)}>} Month)), 'MMM-YYYY') & ' ' & '' &ColumnDim601& ' '
May i know how to change it , when user not click on year and month , how to make it display Jan to Mar 2016
Now it display Jan - Dec 2016 is wrong.
Paul
This:
='Jan - ' & date(makedate(max(year)-0,max({<Year={$(=max(year)-0)}, sales = {'*'}>} Month)), 'MMM-YYYY') & ' ' & '' &ColumnDim601& ' '
Hi sunny
Beautiful it work fine.
Thank
Paul
Hi sunny
why i cannot mark as correct answer ? only can mark as helpful ?
Paul
Because this thread is a discussion thread and not a question thread. It can only be changed within the first 15 minutes from a discussion to question or question to discussion. I don't think you can change it now
Hi sunny
i just notice that there it discussion and question. okay next time i take note , make sure it is question .
Paul
No problem