C Christine Jun 5, 2009 #1 can we set a criteria, say if date>31/12/07 so that sales amt will only include those dated after year 07 tks
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 Jun 5, 2009 #2 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.
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.
