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

Mouimet
You can't query data within a pivot table in this way unfortunately. You can do one of 2 things
If your data is from an external source ie another spreadsheet or Access database then you can use "MS query" to filter your data which is great.
If your data source is in the same spreadsheet then try adding another column that compares your 'days' to a "query cell".
Lets say this cell is "A1"
Your new column would contain a formula if("days"<"A1","Y",N")
So if you decide your parameter is 45 days then enter it in cell A1 your new column will display "Y" if OK or "N" if not.
This new column will now be your page header in your pivot and you select "Y"
You can change the criteria in cell "A1" from 45 days if required then refresh the pivot