+ Reply to Thread
Results 1 to 2 of 2

Multi-sheet Pivot table help

  1. #1
    Registered User
    Join Date
    03-29-2017
    Location
    Miami, Fl
    MS-Off Ver
    Excel 2013
    Posts
    1

    Multi-sheet Pivot table help

    Hello Excel gurus!

    First post! I have for years been able to find my answer without actually posting, however this week I was given a task that I cant quite figure out how to complete. Please excuse my tech savvy ignorance as well, since phrasing what I am trying to accomplish is a challenge by itself.

    So currently I have a pivot table using 7 different production sheets each with familiar structures/formats but unique data. Each sheet is fairly simple data, names of associates in column a, row 1 the kind of document processed and row 2 the number of document processed. When I create the pivot table from the sheets I get all the associates names in column A(starting at row 19) and 50+ columns(row 18) because each sheet is a department processing a different kind of document. I created a slicer so I can click on 1 individuals name and to see what they processed. However, because of the number of columns, its not as streamlined as I(or my director) would like. What I would like is to be able to click the associates name in the slicer and then it show only the type of documents that associate processed. So, I was thinking there should be a formula that will allow the text from row 18 to show only if row 19 has value.

    Going to try and add a screenshot to assist, thanks guys for any help! Feel free to ask additional questions since I know the phrasing of the dilemma is hard to comprehend.

    -David
    Attached Images Attached Images

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

    Re: Multi-sheet Pivot table help

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    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.

+ 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. Writing the loop for updating multi-table MS access file using multi-sheet excel
    By relabz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2016, 03:10 PM
  2. Pivot table- multi page problem
    By jonik95b in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-07-2014, 08:48 AM
  3. Values on first row of multi row pivot table
    By jorad in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-05-2012, 07:31 AM
  4. Pivot table using multi-value column
    By inomata in forum Excel General
    Replies: 1
    Last Post: 09-30-2010, 03:46 AM
  5. Multi-Sheet, Multi-Table Vlookup possible?
    By cte in forum Excel General
    Replies: 6
    Last Post: 09-11-2010, 11:18 AM
  6. [SOLVED] Multi-Sheet Pivot Table Too Large
    By Jack in forum Excel General
    Replies: 2
    Last Post: 03-23-2006, 11:55 AM
  7. Can Multi WorkBooks Be combined in One Pivot Table?
    By dallin in forum Excel General
    Replies: 0
    Last Post: 09-28-2005, 11:05 AM

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