Different Ways to Group Dates in a Pivot table. Tell us about your experience with our site.
Thank you for your feedback! If you want to filter for a date range, move the field to the Row or Column area instead.
Tips Files Products Newsletter Blog search engine by freefind. Please share your views with me in the comment section. Was this information helpful?
Sample File. In a pivot table, you can use date filters to show the results for a specific date or date range. This thread is locked. Thanks for your feedback, it helps us improve the site.
Office Tab: Kutools for Excel , with more than 300 handy functions, makes your jobs more easier. You can follow the question or vote as helpful, but you cannot reply to this thread. Combine and Consolidate Multiple Sheets and Workbooks. Eric Iso 15 Jul, 18 at 8: To post as a guest, your comment is unpublished.
Skip to main content. Site Feedback. Once you create more than one group for dates in the pivot table, you will also get an expanding and collapsing option.