How to do that will depend on which version of xl you are using. The pivot
table engine chaned in 2002 and the coding is different depending which
version you have. Here is a link to Debra's site (she is a pivot table
guru)...

http://www.contextures.com/excelfiles.html#Pivot
--
HTH...

Jim Thomlinson


"funkymonkUK" wrote:


hi

I wanted to find out how do I get a rolling quarter figures as a field
on a pivot table. I know that if I select the months individually I can
get the rolling quarter figures. But I would llike it a bit more
automated as the users I am send this off to have little or no
experience with pivot tables.

Any help much appreciated


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=538517