View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Martin
 
Posts: n/a
Default Calculation of Gross Margin in a pivot table

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