Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set a pivot table to group quarterly reports by F/Y?
I'm trying to set up a report in Excell using the pivot table function. When
I use the "Group Field" function to generate a quarterly report it assigns each quarter according to a calendar year which puts the Jan 2010 data in the 1st QTR and the Oct 2009 data in the 4th Quarter. I want to change this so it begins the 1st QTR in Oct. Is there a way to change the way the pivot table reads and organizes the data? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table reports - repeat the group name on each line | Excel Discussion (Misc queries) | |||
quarterly reports | Excel Worksheet Functions | |||
quarterly reports | Excel Discussion (Misc queries) | |||
quarterly reports | Excel Worksheet Functions | |||
quarterly reports | Excel Worksheet Functions |