Is there a way to do advanced filtering on a pivot chart.
For instance one of the filter selections I have is a list of employee ID's number, is there a way to paste in aa group of only a small selection of employee ide so I only see their results without having to go thru the list and checking the box next number.
The way I would do this (explaining this in Excel 2003 terms) is:
Designate a column where you want to list the employee numbers. Overlay this with a named dynamic range, let's call it Empl_List.
Then in your data source, make a helper column called On_List. Suppose the ID is in column A then the helper column has the formula =ISNUMBER(MATCH(A2,Empl_List,0)) - this evaluates to TRUE if the employee is on the list and FALSE if the employee is not. You can then use this as a Report Filter.
Here is some information on named dynamic ranges: http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks