Today we will learn multi-level pivot table – It is perfectly fine to drag more than one area in a pivot table. We will see an example of multiple row fields, many value fields, and several report filter fields.

Download Excel data file for use with multi-level pivot table

Multiple Row Fields

You have to insert a pivot table. Next, drag the following fields to the different areas.

Step 1. Category field and Country field to the Rows area.

Step 2. Amount field to the Values area.

Multiple Row Fields

Multiple Value Fields

You have to insert a pivot table. Next, drag the following fields to the different areas.

Step 1. Country field to the Rows area.

Step 2. Amount field to the Values area (2x).

Step 3. Next, click any cell inside the Sum of Amount2 column.

Step 4. Right click and click on Value Field Settings

Step 5. Enter Percentage for Custom Name.

Step 6. On the Show Values As tab, select % of Grand Total & Click OK

Multiple Value Fields

Multiple Report Filter Fields

You have to insert a pivot table. Next, drag the following fields to the different areas.

Step 1. Order ID to the Rows area.

Step 2. Amount field to the Values area.

Step 3. Country field and Product field to the Filters area.

Step 4. Next, select United Kingdom from the first filter drop-down and Broccoli from the second filter drop-down.

The pivot table shows all the ‘Broccoli’ orders to the United Kingdom.

Multiple Report Filter Fields