View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Christopher Sequeira[_2_] Christopher Sequeira[_2_] is offline
external usenet poster
 
Posts: 5
Default make pivottable dropdown work like the filter.

I have a database month,datewise and other fileds
say a database from Jan to June.
I have used Pivot Tables. Now if I select the month as May, when I try to
select from the dropdown, I see all the date's, irrespective of the month I
select in the page filed.
Now could I make it function the same way the filter works. probably by
coding.
Any suggestions...how to go about.