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.