How one can Create Two Pivot Tables in Single Worksheet

Generally, chances are you’ll need to create two Pivot tables in single Excel worksheet to report information in two alternative ways. One can find beneath the steps to create Two Pivot Tables in Single Worksheet.

Create Two Pivot Tables in Single Worksheet

As talked about above, the frequent purpose for creating Two Pivot Tables in Single Worksheets is to research and report information in two alternative ways.

For instance, take into account the next Gross sales Knowledge as recorded at 2 completely different retailer places (Retailer#1 and Retailer#2).

For above Gross sales Knowledge, you’ll be able to Create Two Pivot Desk in similar Worksheet, reporting or analyzing Gross sales Knowledge in two alternative ways.

For instance, the First Pivot Desk may be configured to report ‘Gross sales Knowledge by Gadget Kind’ and the second Pivot Desk to report ‘Gross sales Knowledge by Retailer’.

1. Create First Pivot Desk

Comply with the steps beneath to create the First Pivot Desk to point out Gross sales Knowledge by Merchandise.

1. Choose any Cell within the Supply Knowledge > click on on Insert > Tables and choose Beneficial PivotTables choice.

2. On Beneficial PivotTables display screen, select the PivotTable Structure that you simply need to use and click on on OK.

3. When you click on on OK, Excel will insert the primary Pivot Desk in a brand new worksheet.

4. As soon as Pivot Desk is inserted, click on on any Cell throughout the Pivot Desk and this may carry up the ‘PivotTable Fields’ Record.

Modify the primary Pivot Desk as required by including and dragging the Subject Gadgets between Columns, Rows and Values areas.

2. Create Second Pivot Desk in Identical Worksheet

Now, you’ll be able to create a second Pivot Desk in the identical Worksheet by following the steps beneath.

1. Click on on any empty cell in the identical Worksheet – Be certain the Cell is away from the primary pivot desk that you simply simply created.

2. Subsequent, click on on the Insert tab and click on on PivotTable choice.

3. On the following display screen, choose Pivot Desk Vary, choose Current Worksheet choice and click on on the OK button to insert a clean Pivot Desk in the identical Worksheet.

4. As soon as clean Pivot Desk is inserted, construct the second Pivot Desk as required by deciding on objects and dragging them between Columns, Rows and Values areas in PivotTable Fields checklist.

This manner, you’ll find yourself with two Pivot tables on the identical worksheet, reporting gross sales information in two alternative ways.

Every time new gross sales are added, you’ll be able to simply refresh the 2 Pivot Tables and this may replace the info in each Pivot Tables.

Equally, you’ll be able to add as many pivot tables in the identical worksheet as you need and report information in several methods.

How one can Repair Pivot Desk Report Overlap Warning

If you insert two or extra Pivot Tables in the identical Worksheet, chances are you’ll come throughout Pivot Desk Report overlap warning, everytime you attempt to make adjustments within the Pivot Tables.

If this occurs, click on on OK to shut the warning message and easily house out the 2 Pivot Tables.

You possibly can house out Pivot Tables by inserting few clean rows (if Pivot Tables are one above one other) and by inserting some clean columns (if Pivot Tables are aspect by aspect).

If you’re going to change Pivot Tables steadily (including and eradicating fields), it’s higher to maintain the Pivot Tables on separate worksheets.

Associated

• How one can Create Pivot Desk From A number of Worksheets
• How one can Add or Take away Subtotals in Pivot Desk
• Substitute Clean Cells with Zeros in Excel Pivot Desk