Hello all

I am creating this Pivot Table in Excel2003. I have multiple fields:
employees, itemamount, itememountco., expensecategory, department and
period ending. My PivotTable looks perfect but I want to be able to
sort/arrange my data by period ending. In other words be able to set a
range based on the data behind the period ending field. Something where
I can input "10/1/2006 - 11/15/2006" so my PivotTable will display ONLY
data under that range.

Any ideas?

Thanks in advance