+ Reply to Thread
Results 1 to 4 of 4

Using pivot table results in another pivot table

  1. #1
    Registered User
    Join Date
    02-02-2017
    Location
    Vancouver, British Columbia
    MS-Off Ver
    2013
    Posts
    5

    Using pivot table results in another pivot table

    Hi, new to the forum here looking for some pivot experts!

    I have two pivot tables as seen in the attachment. My goal is to be able to filter "Second Level" and automatically have the second pivot (Rightside) filter the associated "User Groups"

    So the end result... if i filtered "Reports (USA)" on the first table, the second table will automatically only show data for the groups Approvers, USA Visitors, and Editors - USA.

    Any tips or suggestions are greatly appreciated!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by HYChau; 02-02-2017 at 05:34 PM.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,056

    Re: Using pivot table results in another pivot table

    See my remarks in your previous post.

    If the data results of the pivot table look like decent source data (It has good column headers and the row headers are repeated) then you can overlay a named dynamic range over the pivot table and use the named range as the data source for the second pivot table.

    This article should get you going on dynamic ranges: http://www.utteraccess.com/wiki/inde...Dynamic_Ranges.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    02-02-2017
    Location
    Vancouver, British Columbia
    MS-Off Ver
    2013
    Posts
    5

    Re: Using pivot table results in another pivot table

    Workbook is attached, thanks. I will look into the article

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,056

    Re: Using pivot table results in another pivot table

    Which one of the pivot tables do you want to use as the new data source? You will have to select the option to repeat row headers in the report.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  2. Pivot Table Results to Secondary Table with Horizontal Results
    By Pony08 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2015, 04:18 PM
  3. Replies: 1
    Last Post: 07-29-2015, 05:19 PM
  4. Replies: 1
    Last Post: 07-29-2015, 05:15 PM
  5. Replies: 0
    Last Post: 07-08-2015, 09:24 AM
  6. Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table
    By ragavendraph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 03:00 PM
  7. Macro Pivot Table vs Manual Pivot Table - different results
    By vodka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2008, 04:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1