| Home > Forum Home > Presenting and Reporting Data > Excel 2007 - Pivot Tables - Combination "Show Items with no data" / "Grouping - Group By Date Range" > Group Start and End Dates and use Custom Filters | Share |
Group Start and End Dates and use Custom Filters
Excel Help for Group Start And End Dates And Use Custom Filters in Presenting and Reporting Data
| Forum Topic | Login |
Group Start And End Dates And Use Custom Filters | Rate this: (3/5 from 1 vote) |
 | When you select the start and end dates in the Pivot table grouping, make sure that you uncheck the "Auto" boxes to force the specified dates to eliminate the unwanted months. I tested this fine with you sample data. In order to filter by month and year, create a custom filter on the data field whereby you select Date Filters > Custom Filter > is not between and then choose the begin date and end date for data not to be shown. This will allow you to filter out a particular month such as in your example. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Group Start and End Dates and use Custom Filters in the Excel Business Solutions Directory |