| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Quarterly report
Hi,
I know Pivot Table has a function that sorts data on the quarterly basis. If I want it to sort by the company's fiscal year (ie, May 1st to July 31st, instead of april 1st to june 30th), can pivot table be sorted in that way? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Quarterly report
There is nothing built in that will do that for you. You will need to include
some indication of your periods in the source data. For instance have a Month, Quarter and Year field right in your source data... -- HTH... Jim Thomlinson "SA" wrote: Hi, I know Pivot Table has a function that sorts data on the quarterly basis. If I want it to sort by the company's fiscal year (ie, May 1st to July 31st, instead of april 1st to june 30th), can pivot table be sorted in that way? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Report - HELP! | Excel Discussion (Misc queries) | |||
| A pivot table report cannot overlap another pivot table report. | Excel Discussion (Misc queries) | |||
| Pivot table report | Excel Worksheet Functions | |||
| Pivot Table Report | Charts and Charting in Excel | |||
| pivot table report | Excel Worksheet Functions | |||
Hybrid Mode
