| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with rolling quarter figure on a pivot table
hi I wanted to find out how do I get a rolling quarter figures as a fiel on a pivot table. I know that if I select the months individually I ca get the rolling quarter figures. But I would llike it a bit mor automated as the users I am send this off to have little or n experience with pivot tables. Any help much appreciate -- funkymonkU ----------------------------------------------------------------------- funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813 View this thread: http://www.excelforum.com/showthread.php?threadid=53851 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with rolling quarter figure on a pivot table
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with rolling quarter figure on a pivot table
I am using xl 2000 but will also be viewed on xl97. if that helps -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=538517 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with rolling quarter figure on a pivot table
can anybody help me? -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=538517 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with rolling quarter figure on a pivot table
not sure if this is a bug but the first item on my page field does not have a drop down list which I can select a value. The rest of the fields on page part of the wizards seems to be fine. -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=538517 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table rolling 12 month filter? | Excel Discussion (Misc queries) | |||
| Rolling Forward Pivot Table Source Data | Excel Discussion (Misc queries) | |||
| Pivot Table with Quarter Subtotals across the top | Excel Discussion (Misc queries) | |||
| Pivot Table with Quarter Subtotals across the top | Excel Worksheet Functions | |||
| Rounding to the nearest quarter (decimal) in a Pivot table | Excel Discussion (Misc queries) | |||
![funkymonkUK[_151_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
