{"id":5143,"date":"2020-04-04T07:34:56","date_gmt":"2020-04-04T07:34:56","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=5143"},"modified":"2024-03-26T11:48:37","modified_gmt":"2024-03-26T11:48:37","slug":"create-pivot-table-in-pivot-table","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/","title":{"rendered":"Create Pivot Table in Pivot Table"},"content":{"rendered":"\n
Create-Pivot-Table-in-Pivot-Table<\/a>Download File<\/a><\/div>\n\n\n\n

Usually, we create Pivot Tables from tables, but you can also create a Pivot Table from the data inside another Pivot Table. In Excel 2003 there was a wizard to create Pivot Tables or Pivot Charts.<\/p>\n\n\n\n

This wizard still exists inside Excel, but it’s hidden. In this lesson, I’ll show you, how you can use it, and also how you can add it to your Quick Access Toolbar, so you are going to have quick access to it any time you want.<\/p>\n\n\n\n

Create a Pivot Table inside another Pivot Table<\/h2>\n\n\n\n

I’m going to use the following table.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
    \n
  1. Create a pivot table from the table.<\/li>\n\n\n\n
  2. Select all Pivot Table fields and move them to\nRows, so the State is at the top.<\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
      \n
    1. Press Left Alt<\/strong> (don’t hold), then d<\/strong>, and then p<\/strong> to open Pivot Table wizard.<\/li>\n\n\n\n
    2. Select Another PivotTable report or PivotChart report<\/strong>.<\/li>\n<\/ol>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
        \n
      1. Choose the Pivot Table, you want to use.<\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
          \n
        1. Choose the cell where you want to place the new Pivot Table.<\/li>\n<\/ol>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
            \n
          1. Place Finish<\/strong> to create the new Pivot Table.<\/li>\n<\/ol>\n\n\n\n

            After you place it, you can click the Pivot Table fields as\nyou did in the previous Pivot Table.<\/p>\n\n\n\n

            Adding Pivot Table wizard to Quick Access Toolbar<\/h2>\n\n\n\n

            If you don’t want to memorize these keyboard shortcuts, you\ncan easily add this wizard to Quick Access Toolbar.<\/p>\n\n\n\n

              \n
            1. Click the icon.<\/li>\n<\/ol>\n\n\n\n
              \"\"<\/figure>\n\n\n\n
                \n
              1. Click More Commands<\/strong>.<\/li>\n\n\n\n
              2. Choose Commands not in the <\/strong>Ribbon<\/a>.<\/li>\n\n\n\n
              3. Search for PivotTable and PivotChart Wizard<\/strong>.<\/li>\n\n\n\n
              4. Click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n

                A new icon appears in Quick Access Toolbar<\/a>. Now, you can\nquickly use it without the need of memorizing keyboard shortcuts.<\/p>\n","protected":false},"excerpt":{"rendered":"

                Usually, we create Pivot Tables from tables, but you can also create a Pivot Table from the data inside another Pivot Table. In…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nCreate Pivot Table in Pivot Table<\/title>\n<meta name=\"description\" content=\"Learn how to create a Pivot Table inside another Pivot Table in Excel with this tutorial. Download the example file to follow along.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create Pivot Table in Pivot Table\" \/>\n<meta property=\"og:description\" content=\"Learn how to create a Pivot Table inside another Pivot Table in Excel with this tutorial. Download the example file to follow along.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-04T07:34:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T11:48:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/04\/table-example.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Create Pivot Table in Pivot Table\",\"datePublished\":\"2020-04-04T07:34:56+00:00\",\"dateModified\":\"2024-03-26T11:48:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/\"},\"wordCount\":271,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/04\/table-example.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/\",\"name\":\"Create Pivot Table in Pivot Table\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/04\/table-example.png\",\"datePublished\":\"2020-04-04T07:34:56+00:00\",\"dateModified\":\"2024-03-26T11:48:37+00:00\",\"description\":\"Learn how to create a Pivot Table inside another Pivot Table in Excel with this tutorial. Download the example file to follow along.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/04\/table-example.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/04\/table-example.png\",\"width\":282,\"height\":280},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create Pivot Table in Pivot Table\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create Pivot Table in Pivot Table","description":"Learn how to create a Pivot Table inside another Pivot Table in Excel with this tutorial. Download the example file to follow along.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/","og_locale":"en_US","og_type":"article","og_title":"Create Pivot Table in Pivot Table","og_description":"Learn how to create a Pivot Table inside another Pivot Table in Excel with this tutorial. Download the example file to follow along.","og_url":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/","article_published_time":"2020-04-04T07:34:56+00:00","article_modified_time":"2024-03-26T11:48:37+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/04\/table-example.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Create Pivot Table in Pivot Table","datePublished":"2020-04-04T07:34:56+00:00","dateModified":"2024-03-26T11:48:37+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/"},"wordCount":271,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/04\/table-example.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/","url":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/","name":"Create Pivot Table in Pivot Table","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/04\/table-example.png","datePublished":"2020-04-04T07:34:56+00:00","dateModified":"2024-03-26T11:48:37+00:00","description":"Learn how to create a Pivot Table inside another Pivot Table in Excel with this tutorial. Download the example file to follow along.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/04\/table-example.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/04\/table-example.png","width":282,"height":280},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-table-in-pivot-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Create Pivot Table in Pivot Table"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/5143"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=5143"}],"version-history":[{"count":5,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/5143\/revisions"}],"predecessor-version":[{"id":13969,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/5143\/revisions\/13969"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=5143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=5143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=5143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}