| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table: group dates by filing period
My PST (Provincial Sales Tax) filing periods are October 1 to March 31
and April 1 to September 30. I'd like to create a pivot table based on my table of purchases (named range: Purchases) and have the dates grouped by filing period. Of course the default ranges don't allow for this kind of flexibility so I'm guessing I'll need some code... Can anyone help me out? Thanks, KZ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Finanical information by Period as a month | Excel Discussion (Misc queries) | |||
| Can't Group Dates in Pivot Table | Excel Discussion (Misc queries) | |||
| Lookup dates, fiscal period table | Excel Worksheet Functions | |||
| Pivot table - group dates per week or month | Excel Discussion (Misc queries) | |||
| Can't group by dates in Excel 2003 pivot table | Excel Discussion (Misc queries) | |||
Threaded Mode
