Pivot Table - divide two results

[Pete Petersen]

I have data setup as follows in a Pivot table

customer Data Jan Grand Total
Sum of Sell
Sum of Gross Profit
Count of Inv
% of total Sales

I want to add another Data output that takes the Sum of Gross Profit/Sum of
Sell for each customer in this pivot table.

Does anyone know how to do this?

Thank you ,

PETE

 

[Debra Dalgleish]

You can add a calculated field to the pivot table:

Select a cell in the pivot table
On the Pivot Table toolbar, choose PivotTable>Formulas>Calculated Field
Type a name for the Field
IN the Formula box, type an equal sign
In the list of fields, double-click on Gross Profit
Type a division operator ( / )
In the list of fields, double-click on Sell
Click OK

 

[Pete Petersen]

Thank you so much for this help....

You can add a calculated field to the pivot table:

Select a cell in the pivot table
On the Pivot Table toolbar, choose PivotTable>Formulas>Calculated Field
Type a name for the Field
IN the Formula box, type an equal sign
In the list of fields, double-click on Gross Profit
Type a division operator ( / )
In the list of fields, double-click on Sell
Click OK

 

[Sunryzz]

I tried this with something similar and I got #DIV-0 for all the fields. Do
you have any idea why that would be?

 

[Debra Dalgleish]

Were both fields numeric?

I tried this with something similar and I got #DIV-0 for all the fields. Do
you have any idea why that would be?

:

 

[Sunryzz]

I think that was my problem. Thank you very much! Now, I just have one more
question. Can you tell me if it's possible to show this calculation only in
the total field for one of my rows instead of in every row?

 

[Carolina]

It seems it only allows you to create formulas from data in the source data.
I want to create formulas using the results of a pivot table. I have a column
that gives me the count of employees and another that gives me the average
lenght of stay in the company. I want to divide the count by the lenght of
stay....these are calculated fields by the pivot table and not available in
the master data. When I try to go to the calculate function those two new
fields are not an option? Hope this is clear>

Carolina