Now, to insert the second table in this same sheet we have to insert the table again. Drag down Product to the Rows area, Yearto the Columnsarea, and Sales to the Values.

Then, you will be taken to a new sheet where you will have two portions PivotTable3, and PivotTable Fields.

Click on the New Worksheet option and press OK.

Select the range of the first table for the Year 2020 in the Table/Range.

Go to the Insert tab > PivotTable dropdown > From Table/RangeĪfter that, you will have the PivotTable from table or range dialog box.

In this step, we will create two pivot tables in one sheet using the two datasets for the years 2020, and 2021. Step-01: Creating Two Pivot Tables in One Sheet Here, we will use the GETPIVOTDATA function to calculate the differences between the sales values of different years. In this article, we will try to compare these two tables either from different values perspectives or from different texts perspectives.Įxample-1: Using Formula to Compare Two Pivot Tables in Excel Here, we have the following two datasets containing the sales record for 20 for different products of a company. 3 Examples to Compare Two Pivot Tables in Excel

Pivot tables in excel values