Pivot - can we set criteria?
can we set a criteria, say if date31/12/07 so that sales amt will only
include those dated after year 07 tks |
Pivot - can we set criteria?
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 |
All times are GMT +1. The time now is 04:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com