Whenever new sales are added, you can just refresh the two Pivot Tables and this will update the data in both Pivot Tables. This way, you will end up with two Pivot tables on the same worksheet, reporting sales data in two different ways. Once blank Pivot Table is inserted, build the second Pivot Table as required by selecting items and dragging them between Columns, Rows and Values areas in PivotTable Fields list. On the next screen, select Pivot Table Range, select Existing Worksheet option and click on the OK button to insert a blank Pivot Table in the same Worksheet.Ĥ. Next, click on the Insert tab and click on PivotTable option.ģ. Click on any empty cell in the same Worksheet – Make sure the Cell is away from the first pivot table that you just created.Ģ. Now, you can create a second Pivot Table in the same Worksheet by following the steps below.ġ.
Create Second Pivot Table in Same Worksheet