+ Reply to Thread
Results 1 to 2 of 2

Create a list of row items from a changing pivot table

  1. #1
    Registered User
    Join Date
    08-21-2014
    Location
    Minneapolis, MN
    MS-Off Ver
    2010
    Posts
    13

    Create a list of row items from a changing pivot table

    Is there a way to quickly (without VBS or macros) generate a list of the main rows from the result of a pivot table when changing search parameters?

    Currently I have a pivot table and I need the main Row contents (ie CATEGORY1, 2, 3 below) for a given column linked to a table. As the pivot table filters change I want the linked list to change accordingly.

    PIVOT TABLE:
    CATEGORY1 DATA DATA DATA DATA
    DATA DATA DATA DATA
    CATEGORY2 DATA DATA DATA DATA
    DATA DATA DATA DATA
    CATEGORY3 DATA DATA DATA DATA
    CATA DATA DATA DATA

    DESIRED RESULT:
    CATEGORY1
    CATEGORY2
    CATEGORY3


    Maximum number of categories is about 30.

    Currently I'm having to copy the column out of the pivot table after every change or update and manually sort, remove duplicates, and copy the categories where they need to go.

    Any thoughts?

    I know there must be a simple Index/Match combination or something to make it work but I'm not a pro with those combinations.

    Any tips on how to make sure I capture everything to the bottom of a shape shifting pivot table as well?

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Create a list of row items from a changing pivot table

    Why not add a second pivot table based on the same data source, and only add the Category field - then link the filters of the two pivot tables by using slicers.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. Create a table/pivot table using different items items from a column
    By stevetton in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-28-2016, 10:30 PM
  2. Replies: 1
    Last Post: 07-16-2015, 05:46 AM
  3. Replies: 6
    Last Post: 11-28-2013, 11:54 AM
  4. Replies: 1
    Last Post: 09-03-2012, 10:03 PM
  5. Replies: 1
    Last Post: 12-31-2009, 11:13 AM
  6. Pivot table.... list of visible items
    By ericlch16 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2007, 01:50 PM
  7. [SOLVED] Changing a pivot table field items to current database
    By Pete Straman Straman via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2005, 01:06 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