Expand field when display only month

expand field when display only month

Different Ways to Group Dates in a Pivot table. Tell us about your experience with our site.

expand field when display only month

Thank you for your feedback! If you want to filter for a date range, move the field to the Row or Column area instead.

How to Group Dates in a Pivot Table

Tips Files Products Newsletter Blog search engine by freefind. Please share your views with me in the comment section. Was this information helpful?

expand field when display only month

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.

expand field when display only month

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.

Group or ungroup data in a PivotTable

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.