Dear Excel 2003 Users,
I created a fairly nice pivot table that feeds a chart showing the
amount of hours for all of the different clients that a person has
worked on. Management liked it but asked a question that left me
scratching my somewhat empty head. Is there any way to filter out the
"less important" clients - e.g. clients that were worked on for less
than 5 hours?
The data for the pivot table originates from an Access database, so I
guess I could always do it there, but I was hoping that there was some
way to have a pull down (similar to the pivot table pull down for the
employee names or client names) on the pivot table sheet that had a
list like this:
Top 10
Top 3
Greater than 10 Hours
Is anything like this even remotely possible? Thanks a million in
advance!
Kevin
Bookmarks