PivotTable from a PivotTable

While it is not technically possible to pivot a pivot table, you can reduce the number of records to analyze by using some of the functionality available in Excel 2010 and later versions.

Download Pivot Table from Pivot Table.xlsx to work along.

The Steps

  1. To accomplish the goal of reducing the amount of data to analyze in a Pivot Table, we can pivot our starting source data and add each desired field to Row Fields. In our example, we’d only like to take the columns through Sum of Warehouse 4.
  2. Things may look a little odd, right now, but in the next few steps this will all make sense. First let’s change the Design of our Pivot Table to Tabular Form. On the PivotTable Tools Design contextual tab, click the Report Layout button in the Layout group. Choose Tabular Form.
  3. Next, remove all Subtotals and Grand Totals by clicking on the Subtotals and Grand Totals combo buttons respectively to turn them off.
  4. Next, back on the Report Layout button, choose Repeat All Item Labels. This will give your worksheet a similar appearance as the original data source, minus the columns you didn’t want.
  5. Click in the middle of your Pivot Table and press Ctrl+A to select all data. Filter out any rows you don’t want, as well. In our case, we’ll take only the first 10 products.
  6. Perform a Paste Values operations into a new worksheet or workbook.
  7. Pivot this new dataset, which contains about ½ of the original data.

So, while we did not actually pivot a Pivot Table, we used the Pivot Table functionality to reduce the volume of source data to the amount we really wanted, performed a copy paste values, and pivoted that!

Local Seminars Related to this Topic:

Microsoft® Excel® Basics

LIVE ONLINE SEMINARS

Sep. 20

Pacific Time Zone

Sep. 21

Central Time Zone

Sep. 22

Eastern Time Zone

Sep. 27

Eastern Time Zone

Sep. 29

Pacific Time Zone

Sep. 30

Central Time Zone

Oct. 4

Eastern Time Zone

Oct. 5

Central Time Zone

Oct. 7

Central Time Zone

Oct. 12

Central Time Zone

Oct. 13

Central Time Zone

Oct. 14

Pacific Time Zone

Oct. 18

Eastern Time Zone

Oct. 19

Central Time Zone

Oct. 21

Central Time Zone

Oct. 25

Pacific Time Zone

Oct. 27

Central Time Zone

Nov. 1

Central Time Zone

Nov. 2

Central Time Zone

Nov. 3

Eastern Time Zone

Nov. 4

Central Time Zone

Nov. 8

Central Time Zone

Nov. 9

Eastern Time Zone

Nov. 15

Pacific Time Zone

Nov. 17

Central Time Zone

Nov. 18

Central Time Zone

Nov. 29

Central Time Zone

Dec. 1

Central Time Zone

Dec. 2

Eastern Time Zone

Dec. 6

Central Time Zone

Dec. 7

Central Time Zone

Dec. 8

Eastern Time Zone

Dec. 9

Pacific Time Zone

Dec. 13

Central Time Zone

Dec. 14

Pacific Time Zone

Dec. 15

Eastern Time Zone

Dec. 16

Central Time Zone

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

Sep. 21

Pacific Time Zone

Sep. 22

Central Time Zone

Sep. 23

Eastern Time Zone

Sep. 28

Eastern Time Zone

Sep. 30

Pacific Time Zone

Oct. 1

Central Time Zone

Oct. 5

Eastern Time Zone

Oct. 6

Central Time Zone

Oct. 8

Central Time Zone

Oct. 13

Central Time Zone

Oct. 14

Central Time Zone

Oct. 15

Pacific Time Zone

Oct. 19

Eastern Time Zone

Oct. 20

Central Time Zone

Oct. 22

Central Time Zone

Oct. 26

Pacific Time Zone

Oct. 28

Central Time Zone

Nov. 2

Central Time Zone

Nov. 3

Central Time Zone

Nov. 4

Eastern Time Zone

Nov. 5

Central Time Zone

Nov. 9

Central Time Zone

Nov. 10

Eastern Time Zone

Nov. 16

Pacific Time Zone

Nov. 18

Central Time Zone

Nov. 19

Central Time Zone

Nov. 30

Central Time Zone

Dec. 2

Central Time Zone

Dec. 3

Eastern Time Zone

Dec. 7

Central Time Zone

Dec. 8

Central Time Zone

Dec. 9

Eastern Time Zone

Dec. 10

Pacific Time Zone

Dec. 14

Central Time Zone

Dec. 15

Pacific Time Zone

Dec. 16

Eastern Time Zone

Dec. 17

Central Time Zone

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

LIVE ONLINE SEMINARS

Sep. 20

Central Time Zone

Oct. 1

Central Time Zone

Oct. 5

Pacific Time Zone

Oct. 6

Central Time Zone

Oct. 12

Central Time Zone

Oct. 21

Central Time Zone

Oct. 25

Eastern Time Zone

Oct. 29

Central Time Zone

Nov. 2

Eastern Time Zone

Nov. 8

Central Time Zone

Nov. 17

Central Time Zone

Nov. 19

Pacific Time Zone

Nov. 29

Central Time Zone

Dec. 3

Central Time Zone

Dec. 8

Central Time Zone

Dec. 9

Central Time Zone

Dec. 14

Eastern Time Zone

Dec. 15

Central Time Zone

Related Excel® Articles

Categories

Monthly Archives

Leave a Reply

Your email address will not be published. Required fields are marked *