Dynamic lables in pivot table

[#1]

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.

[#2]

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