Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my pivot table, I need to show data for today, last month end, last quarter end.
My requirement is that, I wish to show lables as LastMonthEnd <date on last monthend>.
I tried using expression for lable as: 'Prior Quarter End' & =DATE(QuarterEnd(max(Date),-1), 'YYYY-MM-DD')
But it is not working.
However if I use expression as: =DATE(QuarterEnd(max(Date),-1), 'YYYY-MM-DD') & 'Prior Quarter End' then it works.
But I wish to dispaly text 'Prior quarter end' first and then contactinated with date.
Please guide me how to achive it.
Rohit,
Try this out. Problem with your code was "=" sign was misplaced near date. "=" sign should be always at the starting of the expression.
='Prior Quarter End' & DATE(QuarterEnd(max(Date),-1), 'YYYY-MM-DD').
-Sridhar