Calculation of Gross Margin in a pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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 1
Pivot table calculated field error 1
Mark up and Margin 3
Pivot Table Help - Gross Margin % & % of Sales 2
Pivot Table Help - Gross Margin % & % of Sales 1
A What-if scenario changing one figure to work out another 4
How to ignore a column of numbers in Grand Total for rows 1

Back
Top