Use nonstandard fiscal years and quarters in PivotTables

- [Instructor] When you work with dates within pivot tables…it's very easy to segregate the data by years, by quarters,…by month, as we're seeing in this pivot table here.…The source data is over in columns A through E.…And notice the date column is simply…standard date entries, nothing unusual there.…Now this layout is typical,…and for many people it's just what they need,…but what if your fiscal year is,…way you calculate data by quarters.…What if your fiscal year begins in October or July?…The quarters the way we see them here are chronological,…and that's probably what a lot of people want,…but how do we deal with fiscal quarters, fiscal years?…There's no standard way within pivot tables to do this,…but we can make some changes in the source data,…and then accommodate that information.…

So in the source data, I'm going to zoom in,…and put a new column to the left of column E,…actually two new columns.…Right-click column E and insert,…and then I'll press the function key…F4 to repeat that action.…So the heading here is going to be the fiscal quarter,…