We can equally sort our dates from the most recent sales to the oldest and vice versa. We can also ungroup data by right-clicking on any date and select ungroupįigure 5 – How to group pivot table date How To Sort Pivot Table Dates For example, to group by day, we will select Day, enter the Starting and Ending date, and then, click OK. After that, we will assign Date and Products to the Rows label as well as the Sales to the Values sectionįigure 4 – Setting up the Pivot table How To Group Pivot Table Dates
We will set up our Excel data to contain an array of columns and rows.In simple steps, we will explore how to sort, filter, group and format our pivot table dates easily.įigure 1 – Example of how to deal with pivot dates Setting up the Data We can customize our pivot table dates to be displayed in different ways. Learn How to Deal with Dates in a Pivot Table