Hi.
I have a pivot table and chart based on data. I have multiple pivot filters. 1st being Cost Center, 2nd being People's names (Every person is associated to only one cost center - many people in each cost center - many cost centers). When I set the pivot table filter for cost center, I would like the 2nd filter to only show people's names in that cost center, not all names in all cost centers which is what it shows. Any way to do that?
Thanks
Steve
Harrisburg, PA
Bookmarks