Excel 2002 Pivot Table - Add Calculated Field

[NJko4]

Have pivot table where the page field is Vendor Name; the column field is service_month and the data elements are Sum of Paid, and Sum of Units.

There are 12 service months - from Jan through Dec.

What I am trying to accomplish is to insert a column after each service month that displays the percentage of the row value (paid amount for the vendor) relative to the total amount paid to all vendors.

Have not been able to do this!

When I create a calculated field, it is added to the row and I am not able to create a column.

Any insight appreciated.

 

[SkipVought]

What about pulling AmountPaid, AGAIN as a second aggregation, into the DATA area and selecting SUM and then OPTIONS on that field as % of column.

Skip,
[sub]
Just traded in my old subtlety...
for a brand NUANCE![/sub]