1 Reply Latest reply: Jul 27, 2011 5:24 AM by Sridhar Ethiraj RSS

    Dynamic lables in pivot table

      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.