View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mouimet Mouimet is offline
external usenet poster
 
Posts: 41
Default Pivot Table criteria

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