Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting range criteria in pivot table | Excel Discussion (Misc queries) | |||
how to i pivot a table using various criteria | Excel Worksheet Functions | |||
criteria for Pivot Table | Excel Discussion (Misc queries) | |||
Date range criteria and Pivot tables (again!) | Excel Worksheet Functions | |||
I am trying to use get pivot data with variable criteria | Excel Worksheet Functions |