Pivot tables

[Farid]

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.

 

[ryguy7272]

Use the getpivotdata function, as described here:
http://www.contextures.com/xlPivot06.html

It takes a little getting-used-to. If you don't get the results you want at
first, keep trying; that function WILL work for you...

Regards,
Ryan---

 

[Farid]

Thanks Ryan it works!

Use the getpivotdata function, as described here:
http://www.contextures.com/xlPivot06.html

It takes a little getting-used-to. If you don't get the results you want at
first, keep trying; that function WILL work for you...

Regards,
Ryan---

 

[ryguy7272]

Great! Glad it worked out for you!!
Ryan---