how to combine pivot tables in excel 2013

Your PivotTable appears with the first column containing the Row Labels – Salesperson and Month the next four columns containing the Column Labels – Region and a last column Grand Total as given below.ĭrag the field Month from ROWS to COLUMNS.ĭrag the field Region from COLUMNS to ROWS. The fields that are put in COLUMNS area appear as columns in the PivotTable, with the Column Labels being the values of the selected fields.ĭrag the field Region to COLUMNS area. Your PivotTable appears with one column containing the Row Labels – Salesperson and Month and a last row as Grand Total, as given below. Drag the field Salesperson to ROWS area.The fields that are put in ROWS area appear as rows in the PivotTable, with the Row Labels being the values of the selected fields.įor example, consider the Sales data table. You can optionally, drag a field to the ROWS area. If you select the fields in the PivotTable Fields lists by just checking the boxes, all the nonnumeric fields will automatically be added to the ROWS area, in the order you select. You can just drag the fields across these areas and observe how the PivotTable Layout changes. Filters for any of the fields (FILTERS area).How to summarize your data (∑ VALUES area).What fields to display as columns (COLUMNS area).What fields to display as rows (ROWS area).The message - Drag fields between areas below appears above the areas. There are four PivotTable areas available − In this chapter, you will learn about the PivotTable areas. You have already learnt about PivotTable Fields Task Pane in the earlier chapter on PivotTable Fields in this tutorial. As you can simply drag the fields across areas, you can quickly switch across the different layouts, summarizing the data, in a way you want. By arranging the selected fields in the areas, you can arrive at different PivotTable layouts. PivotTable areas are a part of PivotTable Fields Task Pane.

How to combine pivot tables in excel 2013