Show only last 4 quarters in pivot table

[#1]

Hi All,

I need to show only last 4 quarters in pivot table

here in this scenario from 2011Q4 to 2012Q3

Please find attached QVW

[sujeetsingh]

Tru to use the sttraught table and use option dimension limit in properties...and then set the restrictions and see whether working or not..

[kumarnatarajan]

Hi,

Please find the attached file

Thanks & regards,

Kumar N

[jagan]

Hi Ganesh,

Try this expression

2011Q4 - 2012Q3  = Sum({<BilledDate={'>=$(=QuarterStart(Max(BilledDate), -4))<=$(=QuarterEnd(Max(BilledDate), -1))}>} Sales)

Hope this helps you.

Regards,

Jagan.