Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table "Filtering"
Here's my problem:
In XL2000, I am using a pivot table to combine two large data sources. What I want to do is use the smaller list in one database as the main reference. However, every time I combine the two tables, I get a list that features the larger list. How can I force it to filter for only the smaller list? For example, if I have ten employees, and I want to combine their past performance from a larger employee database into a Pivot Table without getting all the other employees, how can I do that? This is just an example, but you get the idea. What I have been doing is using the multiple consolidation ranges option ... is that a bad idea? |
#2
|
|||
|
|||
Assuming all your headers are the same, drop the two lists one under the
other in a single sheet, add another column and put a flag against each list, eg LIST1 and LIST2 against the other. Then just drag that field into the Page fields and use it to focus on whichever list you want. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Jacinthe" wrote in message ... Here's my problem: In XL2000, I am using a pivot table to combine two large data sources. What I want to do is use the smaller list in one database as the main reference. However, every time I combine the two tables, I get a list that features the larger list. How can I force it to filter for only the smaller list? For example, if I have ten employees, and I want to combine their past performance from a larger employee database into a Pivot Table without getting all the other employees, how can I do that? This is just an example, but you get the idea. What I have been doing is using the multiple consolidation ranges option .... is that a bad idea? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - Filtering Page Field | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |