Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm runnung Excel 2003
I create a Pivot table to see sales, refused and Pending if days is < than 45 In my data table I have a column showing 2,3,4, 40, 45, 48, etc. called "Days" In the Pivot Table I add this field "Days" in the section: PAGE of the Pivot table This is my first criteria. Nobody should change this. how can I add a formulas in this pivot table saying =Days<45 I tried with the ( formulas, Calculated Field), however I can not add this in the Page section. I received a message saying I can not add in this section the formulas. I can add it only in the Data field. Does someone know how I can select the Data in this area? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - Format Columns based on Criteria | Excel Worksheet Functions | |||
change/set pivot table autofilter criteria with macro button | Excel Discussion (Misc queries) | |||
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) |