Pivot Tables: Adding a cross column calculated field?

[clawlan]

Is there a way to add a calculated field that uses data from two different columns? In the image below, here is the formula i need to create: (Gross Demand-Incremental Demand)/Gross Demand.

I cant figure this out in excel 2007....

 

[andiemac]

In 2007, after you've made the pivot table, in the PivotTableTools Options ribbon, the Tools section (after Actions before Show/Hide) choose Formulas. This will drop down and give the option of Calucated Fields. A window pops up. Give your new field a name, then build your formula like you have it shown:
= (Gross Demand-Incremental Demand)/Gross Demand

You can click them in from the Fields list below or just type them in. Now you should have a new field in your field list to choose.

In 2003 is the Formulas option under the Pivot Table menu from the Pivot Table tool bar.

 

[clawlan]

In 2007, after you've made the pivot table, in the PivotTableTools Options ribbon, the Tools section (after Actions before Show/Hide) choose Formulas. This will drop down and give the option of Calucated Fields. A window pops up. Give your new field a name, then build your formula like you have it shown:
= (Gross Demand-Incremental Demand)/Gross Demand

You can click them in from the Fields list below or just type them in. Now you should have a new field in your field list to choose.

In 2003 is the Formulas option under the Pivot Table menu from the Pivot Table tool bar.

this does not work because Gross Demand and Incremental Demand are not their own fields. You'll notice in the image that there is a category called "Gross" that contains Demand, Orders, and AOV, then another Category called "Incremental" that contains Demand, Orders, and AOV.

I am trying to take the Demand subcategory of Gross and the Demand subcategory of Incremental and perform the aforementioned calculation.

 

[andiemac]

You image does not show to me, so I was going off your stated request of using 2 columns.

 

[clawlan]

You image does not show to me, so I was going off your stated request of using 2 columns.

here is a link to the image: i.imgur.com/U7Mwd.png

 

[bahjat]

Re: Pivot Tables: Adding a formula to a column calculated field?

Dear Sirs;

Good evening.
Wish you have a nice day.

I'm using excel 2003
After I do the PT from excel sheet the calculating formula is not active in PT
and also not in order even I do sort by date column.


best regards;

Bahjat