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!