Calculation of Gross Margin in a pivot table

G

Guest

Hello everyone

I am trying to calculate the Gross Margin ( (Sales-cost)/Sales ) within a
pivot table so the total calculate the gross margin of the total sales and
Total cost. (The Average DO NOT work because of this formula.)

Please Help
 
G

Guest

First make sure you have the pivot table toolbar appearing.

Then on the toolbar select
Pivot-table..>formulas -->calculated field
and enter the exact same formula by clicking on the fields (sales,costs )
on the formula bar

Hit OK and change the format to %

This will be the gross margin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Pivot table calculated field error 1
Mark up and Margin 3
pivot table 1
A What-if scenario changing one figure to work out another 4
Pivot Table Help - Gross Margin % & % of Sales 2
Pivot Table Help - Gross Margin % & % of Sales 1
subtotal by a range 4

Top