Grouping issues in Excel pivot table learning

In the previous article "Excel Pivot Table Learning: How to Combine Dates", we learned about the date combination of Excel Pivot Table. Today we continue to learn Excel Pivot Tables and explain the grouping issues in Pivot Tables. I hope it will be helpful to everyone!

In yesterday’s pivot table tutorial, we learned how to group dates in a pivot table.

After reading the tutorial, my partners discovered a problem during their actual work and practice: "The selected areas cannot be grouped." As shown in the figure below:

#The two worksheets in the case are: sales outbound data and attendance data cannot be grouped. During the operation, the following error occurred:

The pivot table dates cannot be grouped, usually due to the following three reasons:

First, combine the data There are blank cells in the items

Secondly, there are irregular date-type data in the grouping field data

Thirdly, when the pivot table refers to the data source, it adopts the whole column reference method

Related learning recommendations: excel tutorial

The above is the detailed content of Grouping issues in Excel pivot table learning. For more information, please follow other related articles on the PHP Chinese website!