Pivot Tip 26 - How to analyse sales by financial year. By David Carter
ExcelZone's Five Minute Tips aim to develop your skill at using Excel pivot tables. To test these tips for yourself, try them out on your copy of the pivot_practice.xls database.
When you use the Group function to summarise dates, Excel groups by calendar year. But organisations need to report by financial year, and that will usually be different.
To report by financial year you will need to hold the financial year and period number in your source database.