View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mrc1986 via OfficeKB.com mrc1986 via OfficeKB.com is offline
external usenet poster
 
Posts: 10
Default controlling pivot table

I am new to povit tables, I have just actually discoverd how handy they can
be. I am wondering if the filters can be either linked or controled by a cell
value. lets say that I have dates, customers, services, and prices that I am
sorting in a pivot table. What I am trying to sort by is month and by
customer. I would like to be able to have one cell control the month filter
and anther control the customer filter. Any help would be greatly
appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200807/1