Pivot - can we set criteria?

C

Christine

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

tks
 
D

Dave Peterson

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.
 
Top