| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add a group or filter to pivot table from another sheet or work bo
Hi
I am using Excel 2007 I have a pivot table without source data. I need to add a new group (fliter) based on data located in another sheet.(both tables have customer ID column in common) in other words the first sheet give me the information about customer sales performance( pivot table without source data) In other sheet I assign customer ID with a sales staff. now I want to have sales staff performance as per assigned customer ID. I appreciate if any one can help me. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| How do I protect sheet, but allow "group" function to work | Excel Discussion (Misc queries) | |||
| Pivot Table - no group on web | Excel Discussion (Misc queries) | |||
Hybrid Mode
