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.