Hi guys,
I'm back here to get some help with all of you excel experts!!
I am hoping someone can help me with this pivot table question as I'm trying to do it for work tomorrow!!
I have not been able to sit still because I cannot stop thinking about how to do it, cannot seem to find answers online...
What I'm trying to do (see attached file) with rows of data and columns. This is a report I'd like to implement for everyone in the team to use - they will just need to pick who's the name of project manager or region, then rows of data will show up based on what they choose. I know we can simply use FILTER function, but it's easier if they could just pick from a list...(Some people don't even know how to use filter function!)...
Screen Shot 2016-11-14 at 9.32.22 PM.png
I'm trying to use Pivot table with filters drop down list for project manager, Procurement project manager, regions - depending on what people chose from the drop down list. For example, if they pick "Will" as project manager, the Pivot table will show all rows of data from Column E through L ; or from Column B through L, whatever Column of data I want...
For example, if I were to have the pivot table working, I would pick "Will" as project manager from drop down list from Pivot table, 3 rows of data will show up, including category carpet, stone and wood flooring in this example. See below.
Screen Shot 2016-11-14 at 9.32.02 PM.png
How can I use pivot table to do this? I have attached a sample file - this is only a little portion of the data....
THANK YOU SO MUCH!!!!!
Bookmarks