Were both fields numeric?

Sunryzz wrote:
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" wrote:


You can add a calculated field to the pivot table:

Select a cell in the pivot table
On the Pivot Table toolbar, choose PivotTableFormulasCalculated 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 wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html