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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date mismatching 2
Dates 9
Concatenating Criteria in DSUM 2
Allocate an income payment over a date range (tax years) 7
Pivot Table showing wrong data 1
Returning a Date with Multiple Criteria Lookup Values 0
Can we use outlook calendar as an universal place post work schedules for all the users? 0
Pivot Table Calculated Field 0

Top