You could add a field to the source data, to calculate if the record
should be shown in the pivot table. For example, with dates in column A:

=AND(A2=StartDate,A2<=EndDate)

StartDate and EndDate are named ranges, where the date range could be
manually entered or calculated.

In the pivot table, add the new field to the Page area, and select TRUE
from its dropdown list.


erick-flores wrote:
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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html