Posted to microsoft.public.excel.worksheet.functions
|
|
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.
|