Show data in pivot table by month??

[olimits7]

Hello,

I read this tip on MrExcel where it shows you how to group the dates by month, which worked fine. But the only problem I'm still having is it sorts the months to a calendar year. I need it to stay in the order of our fiscal year which runs from November to October.

Here is the link for the tip I read.

http://www.mrexcel.com/tip047.shtml

Does anybody know a way to keep it from sorting to a calendar year??

Thank you,
olimits7

 

[PaddyD]

2 possibilities:

1) in the source data, add an extra column to flag which month of the fiscal year each record is & use that

2) set up a custom list to drive the sort (see excel help file 'Create a custom fill series or sorting order', though the fact that you're using months might prove problematic - they're probably reserved