Ungroup Command
Follow the below steps to Undo the Date Grouping by Ungroup Command
Step 1: Add the Date field to the Pivot Table
Step 2: At any time, right-click on any of the date field items or headings.
Step 3: In the right-click menu, click Ungroup
Step 4: The grouped Fields are removed, and the original date field remains in the Pivot table.
How to Group or Ungroup Data in a PivotTable
Pivot Table Grouping is a feature that enables us to organize data into specific categories or ranges. It allows you to group data based on various factors, such as dates, numbers, or custom-defined intervals, making it easier to analyze and draw insights from the data. We will explore Pivot table grouping and how it can help you gain deeper insights and make informed decisions from your data.