M
Mouimet
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
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