Hi I have one pivot table, source data sheet is not available. it has
Page filter month
Customer ID fields + Sales amount + total sales + % sales to total
in othe sheets I have
customer ID + sales rep
customet ID + city
the question is how I can have a pivot table in which I can find my data as
per location and sales rep which is in other sheets.
I appreciate if anyone can help me.