Excel2013 Pivot table field grouping

First insert a PivotTable report, and under Insert, click PivotTable

Here, select the default settings. Click OK

Drag the category into the field, the number dragged into the Value field, as shown in the figure

Now we can see that the PivotTable report is ready, and we're going to divide it.

Select the type of vegetable, press CTRL and see that you can select multiple cells that are not contiguous

Click "Group Selection" under the "Analysis" option.

You'll see there's a new column in kind 2 Here we change the category name for vegetables

Next, we choose the other kind.

In the same way we set up the Data Group 2 and rename it to fruit.

At this point, our field groupings are made

Classification:

• Excel Tutorials