| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivottable Qtr's
Hi all
I'm grouping data by Qtr's and by months on column headings. Qtr1 always starts at the January, but I want to get Qtr1 to start in April ?? Help! reagrds johnb |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivottable Qtr's
Add a column into your source data to calculate the quarter. I don't think
you can change the grouping option for when quarters start. -- HTH... Jim Thomlinson "johnb" wrote: Hi all I'm grouping data by Qtr's and by months on column headings. Qtr1 always starts at the January, but I want to get Qtr1 to start in April ?? Help! reagrds johnb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
| Group qtr's in pivottables | Excel Discussion (Misc queries) | |||
| How does one get the PivotTable report info that feeds another PivotTable report? | Excel Programming | |||
| PivotTable - PivotTable Field name is not valid - error! | Excel Programming | |||
| Creating a PivotTable Report from an Another PivotTable Report | Excel Programming | |||
Linear Mode
