Concerned about the latest vaccine mandate? Visit Pryor's free training resource page to learn more about the latest rulings on the national 100+ vaccine mandate.

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!


Choose a Seminar and Save $10:

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small> Basics

Microsoft® Excel® Basics

LIVE ONLINE SEMINARS

Jan. 24

Central Time Zone

Jan. 26

Central Time Zone

Jan. 27

Eastern Time Zone

Jan. 31

Central Time Zone

Feb. 2

Central Time Zone

Feb. 3

Eastern Time Zone

Feb. 7

Central Time Zone

Feb. 8

Eastern Time Zone

Feb. 10

Central Time Zone

Feb. 14

Central Time Zone

Feb. 16

Eastern Time Zone

Feb. 16

Central Time Zone

Feb. 22

Central Time Zone

Feb. 24

Pacific Time Zone

Mar. 1

Central Time Zone

Mar. 2

Eastern Time Zone

Mar. 7

Central Time Zone

Mar. 9

Central Time Zone

Mar. 14

Central Time Zone

Mar. 16

Central Time Zone

Mar. 17

Eastern Time Zone

Mar. 22

Central Time Zone

Mar. 24

Central Time Zone

Mar. 28

Eastern Time Zone

Mar. 29

Central Time Zone

Mar. 31

Pacific Time Zone

Apr. 4

Eastern Time Zone

Apr. 5

Central Time Zone

Apr. 7

Central Time Zone

Apr. 11

Central Time Zone

Apr. 12

Pacific Time Zone

Apr. 13

Eastern Time Zone

Apr. 19

Central Time Zone

Apr. 20

Central Time Zone

Apr. 21

Eastern Time Zone

Apr. 25

Eastern Time Zone

Apr. 27

Central Time Zone

Apr. 28

Pacific Time Zone

May. 2

Eastern Time Zone

May. 4

Central Time Zone

May. 5

Pacific Time Zone

May. 9

Eastern Time Zone

May. 10

Central Time Zone

May. 12

Central Time Zone

May. 16

Central Time Zone

May. 17

Pacific Time Zone

May. 18

Central Time Zone

May. 19

Eastern Time Zone

May. 24

Eastern Time Zone

May. 25

Central Time Zone

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>: Beyond the Basics

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

Jan. 25

Central Time Zone

Jan. 27

Central Time Zone

Jan. 28

Eastern Time Zone

Feb. 1

Central Time Zone

Feb. 3

Central Time Zone

Feb. 4

Eastern Time Zone

Feb. 8

Central Time Zone

Feb. 9

Eastern Time Zone

Feb. 11

Central Time Zone

Feb. 15

Central Time Zone

Feb. 17

Eastern Time Zone

Feb. 17

Central Time Zone

Feb. 23

Central Time Zone

Feb. 25

Pacific Time Zone

Mar. 2

Central Time Zone

Mar. 3

Eastern Time Zone

Mar. 8

Central Time Zone

Mar. 10

Central Time Zone

Mar. 15

Central Time Zone

Mar. 17

Central Time Zone

Mar. 18

Eastern Time Zone

Mar. 23

Central Time Zone

Mar. 25

Central Time Zone

Mar. 29

Eastern Time Zone

Mar. 30

Central Time Zone

Apr. 1

Pacific Time Zone

Apr. 5

Eastern Time Zone

Apr. 6

Central Time Zone

Apr. 8

Central Time Zone

Apr. 12

Central Time Zone

Apr. 13

Pacific Time Zone

Apr. 14

Eastern Time Zone

Apr. 20

Central Time Zone

Apr. 21

Central Time Zone

Apr. 22

Eastern Time Zone

Apr. 26

Eastern Time Zone

Apr. 28

Central Time Zone

Apr. 29

Pacific Time Zone

May. 3

Eastern Time Zone

May. 5

Central Time Zone

May. 6

Pacific Time Zone

May. 10

Eastern Time Zone

May. 11

Central Time Zone

May. 13

Central Time Zone

May. 17

Central Time Zone

May. 18

Pacific Time Zone

May. 19

Central Time Zone

May. 20

Eastern Time Zone

May. 25

Eastern Time Zone

May. 26

Central Time Zone

Advanced Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>-Macros, PivotTables, Charts and More

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

LIVE ONLINE SEMINARS

Jan. 24

Central Time Zone

Jan. 26

Pacific Time Zone

Feb. 2

Eastern Time Zone

Feb. 4

Central Time Zone

Feb. 8

Pacific Time Zone

Feb. 9

Central Time Zone

Feb. 15

Eastern Time Zone

Feb. 18

Central Time Zone

Feb. 24

Central Time Zone

Mar. 3

Central Time Zone

Mar. 8

Eastern Time Zone

Mar. 11

Central Time Zone

Mar. 16

Pacific Time Zone

Mar. 21

Central Time Zone

Mar. 23

Eastern Time Zone

Mar. 31

Central Time Zone

Apr. 4

Central Time Zone

Apr. 6

Eastern Time Zone

Apr. 12

Eastern Time Zone

Apr. 14

Central Time Zone

Apr. 21

Eastern Time Zone

Apr. 22

Central Time Zone

Apr. 26

Central Time Zone

Apr. 27

Pacific Time Zone

May. 4

Central Time Zone

May. 5

Eastern Time Zone

May. 10

Central Time Zone

May. 12

Pacific Time Zone

May. 17

Eastern Time Zone

May. 20

Central Time Zone

May. 23

Central Time Zone

Related Excel® Articles

PRYOR+ 7-DAY FREE TRIAL


Experience 7-days of unlimited learning, then reap the benefits from a year of training at one low price. No credit card. No commitment. Individuals and teams.

Categories