Hello,
I have a pivot table in which I have some data, and one of the fields is date. I have put this date in the 'report filter' , but here it shows me all the different distinct dates in the filter drop down. What I want is to put in a date range, say everything after 1st of June 2009, and then the pivot should consider only that data, but I couldn't find this option anywhere. Can it be done pls...

PS: I use XL 2007..