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.