How one can Create Two Pivot Tables in Single Worksheet

Generalment, chances són el que necessiteu per crear 2 pivotes taules en una excel·lent worksheet per report information a 2 alternatives. One can find beneath the steps to create Two Pivot Tables in Single Worksheet.

Crea't Two Pivot Tables in Single Worksheet

Per tal que hi hagi cap amunt, la freqüència purpose per crear dues pivotes taules en single worksheets és a la recerca ia l'informe informatiu en les dues alternatives.

Per instance, tingueu en compte la seva gross sals Knowledge es recorda al 2 completely different retailer places (Retailer#1 and Retailer#2).

Per sobre Gross sales Knowledge, vostè be able per crear Two Pivot Desk in similar Worksheet, reporting or analyzing Gross sales Knowledge in two alternative ways.

Per a instance, la First Pivot Desk és configurada per report 'Gross sales Knowledge by Gadget Kind' i el segon Pivot Desk per report 'Gross sales Knowledge by Retailer'.

1. Create First Pivot Desk

Complir amb les steps beneath to create the First Pivot Desk to point out Gross sales Knowledge by Merchandise.

1. Trieu qualsevol Cell within the Supply Knowledge > click on on Insereix > Taules I tria Beneficial PivotTables elecció.

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 brand new worksheet.

4. Aixó son Pivot Desk is inserted, click on on any Cell throughout the Pivot Desk and this mai carry up the 'PivotTable Fields' Record.

Modify the primary Pivot Desk és requerit by including and dragging the Subject Gadgets between Columns, Rows and Values ​​areas.

2. Create Second Pivot Desk in Identical Worksheet

Nou, vostè pot crear-se a second Pivot Desk en la mateixa Worksheet per sota de steps beneath.

1. Click on on any empty cèl · lula en el mateix Worksheet – Be certain the Cell és away de la prima pivot desk that you simply simply created.

2. Subsequent, click on on the Insereix tab and click on on Taula dinàmica elecció.

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

4. Així que les clean Pivot Desk s'insereixen, construct the second Pivot Desk es required by deciding on objects and dragging them between Columns, Rows and Values ​​areas in PivotTable Fields checklist.

Aquest manner, vostè find yourself with 2 pivot tables en la mateixa feina, reporting gross sales information in 2 alternative ways.

Every time new gross sales són added, vostè pot ser que simplement refresh el 2 pivot taules i aquest mai replace el info en ei pivot taules.

Equally, vostè be able to add a many pivot tables in the identical worksheet als need and report information in several methods.

How one can Repair Pivot Desk Report Overlap Warning

Quan inseriu dues or extra Pivot Taules en la mateixa Worksheet, chances són el que menja throughout Pivot Desk Report overlap warning, everytime vostè attempt to make adjustments within Pivot Tables.

If this occurs, click on OK per carregar missatges de seguretat i easily house out the 2 Pivot Tables.

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.

associat

• 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