We have added a new name called Vidya to the data source and updated the Pivot table and the resulting table will look as shown below. Suppose a new employee has joined the organization and you want to include him in one of the groups. Hence it is a good practice to add a meaningful name to the group. The table above is not presentable as all the groups have a generic name and you cannot differentiate between who belongs to which department. The new field is positioned above the original field. Now if you notice in the PivotTable Fields, a new field is created called as Employee Name2 and it’s automatically added to the Rows area. All the groups have been automatically given a generic name called Group1, Group2, etc. #4) Similarly, select the other names that you want to group together and click on Group in the context menu.ģ groups are created based on the selection that we have made. #3) Right-click on one of the selected names and click on Group in the context menu.
#2) Now press the Ctrl key on the keyboard and select all the other employees you want to add to the same group. #1) Click on the first name you want to add to the group. To achieve this, follow the below-mentioned steps. Now suppose all these employees belong to different departments like HR, IT & Admin and you want to group all the employees belonging to a single department under one group. Before we jump into grouping, let’s create a Pivot table with the Employee Name under the Rows Area.
0 kommentar(er)
