If you don't see the Field List, try right-clicking anywhere in the PivotTable to click Show Field List. It appears when you click anywhere in the PivotTable. If a workbook you’ve opened in Excel for the web has a PivotTable, you can use the Field List to add, remove, or arrange its fields. More about PivotTablesĬreate a PivotTable to analyze data in multiple tables To delete a field from the PivotTable, drag the field out of its areas section. If you have more than one field in an area, you can rearrange the order by dragging the fields into the precise position you want. Values area fields are shown as summarized numeric values in the PivotTable, like this: Rows area fields are shown as Row Labels on the left side of the PivotTable, like this:ĭepending on the hierarchy of the fields, rows may be nested inside rows that are higher in position. Use the areas section (at the bottom) of the Field List to rearrange fields the way you want by dragging them between the four areas.įields that you place in different areas are shown in the PivotTable as follows:įilters area fields are shown as top-level report filters above the PivotTable, like this:Ĭolumns area fields are shown as Column Labels at the top of the PivotTable, like this:ĭepending on the hierarchy of the fields, columns may be nested inside columns that are higher in position.

NOTE: Typically, nonnumeric fields are added to the Rows area, numeric fields are added to the Values area, and Online Analytical Processing (OLAP) date and time hierarchies are added to the Columns area. Use the field section of the Field List to add fields to your PivotTable, by checking the box next to field names to place those fields in the default area of the Field List. Tip: If you want to change how sections are shown in the Field List, click the Tools button and then pick the layout you want.Īdd and rearrange fields in the Field List

Complex pivot tables in excel 2013