How to add fields to a pivot table

The fields in a pivot table correspond to columns in the source data.

Let’s take a look.

Here we have a set of data that’s already formatted as anExcel Table.

Let’s use this table to create a pivot table and add some fields.

Let’s accept the defaults, and let Excel create the pivot table on a new worksheet.

A new pivot table doesn’t have any fields, so our first task is to add some.

Fields added to the Values area appear inside the table.

it’s possible for you to see how the field list pane mimics the pivot table layout.

To remove a field, just uncheck the box.

Or, simply drag the field out of the field list pane.

it’s possible for you to also opt for field drop-down menu and select Remove Field from the menu.

Finally, you’re able to add a field by right-clicking.

Right-click and choose a location from the menu.

Then select Clear All.

All fields will be removed from the pivot table at once.