Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Tru to use the sttraught table and use option dimension limit in properties...and then set the restrictions and see whether working or not..
Hi,
Please find the attached file
Thanks & regards,
Kumar N
Hi Ganesh,
Try this expression
2011Q4 - 2012Q3 = Sum({<BilledDate={'>=$(=QuarterStart(Max(BilledDate), -4))<=$(=QuarterEnd(Max(BilledDate), -1))}>} Sales)
Hope this helps you.
Regards,
Jagan.