Pivot Table?

[Ken]

Excel 2000 ... No answer to previous post (11/04) so will
attempt to clarify & try again today ...

I have several columns of data ... For 1 Col I wish to
express a "sum" on the Pivot Table ... I am new to Pivot
Tables, but I have no problem with this.

For a 2nd Col ... I wish the Pivot Table to express (the
total sum) as a percentage of the other Col.

Assume "sum" of Col A = 120 & "sum" of Col B = 30.

I would like Pivot Table to return the following values:

Col A = 120
Col B = 25%

Is it possible to setup Pivot Table to do this ... & if
so ... How? ... Thanks ... Kha

 

[Debra Dalgleish]

You can create a calculated field:

Select a cell in the Pivot Table
On the PivotTable toolbar, choose PivotTable>Formulas>Calculated Field
Type a name for the formula
In the formula box, type: =
In the Field list, double-click the Col B field
Type a slash: /
In the Field list, double-click the Col A field
Click OK, then format the column as Percent