I like to add an extra column in the data table that returns true or false.

=a2=date(2008,1,1)

Then I can use that as a page field in the pivottable.



Christine wrote:

can we set a criteria, say if date31/12/07 so that sales amt will only
include those dated after year 07

tks

--

Dave Peterson