Calculation of Gross Margin in a pivot table

M

Martin

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
 
N

N Harkawat

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

Profit and Loss different sections "Excel P&L template" 3
How to ignore a column of numbers in Grand Total for rows 1
Pivot Table Help - Gross Margin % & % of Sales 1
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Calculation on Pivot table running totals 0
A What-if scenario changing one figure to work out another 4
Access 2007 pivot - how to calculate eg P/L marings both in curr & 0
Pivot table calculated field error 1

Top