Pivot tables
 

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.

Pivot tables
 

Use the getpivotdata function, as described he
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---
--
RyGuy


"Farid" wrote:

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.

Pivot tables
 

Thanks Ryan it works!

"ryguy7272" wrote:

Use the getpivotdata function, as described he
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---
--
RyGuy


"Farid" wrote:

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.

Pivot tables
 

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

--
RyGuy


"Farid" wrote:

Thanks Ryan it works!

"ryguy7272" wrote:

Use the getpivotdata function, as described he
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---
--
RyGuy


"Farid" wrote:

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.