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
Bookmarks