pivot table percentage in a row?

  • Thread starter Thread starter Charles Williams
  • Start date Start date
C

Charles Williams

Create a calculated pvot field and drag it to the row position.

You create a calculated pivot field by first creating your pvot table, then
selecting it and presssing Insert -->Calculated Field, or by right clicking
inside the pivot table .

see Help for more details.

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
 
how do I create totalled %

Business units A B C Total

Revnue $10,000

Gross Margin$ $4,000
Gross margin % 40%

how to make the total gross margin %, to show in row below the margin ie
the 40%
in a pivot table??

Pls help

pls help
 
Back
Top