CODEWITHSUNDEEP
excelpivot
Homer_J
Homer_J

Reputation: 3323

Excel Pivot Table add % column

I have a Pivot:

City           HC    TC
--------------------------------
London         50    100
Manchester     67    250
Leeds          20    20

All I need to do is, within the Pivot table, add another column that calculates the percentage based on the second and third columns.

The outcome would be:

City           HC    TC
--------------------------------
London         50    100    50%
Manchester     67    250    27%
Leeds          20    20     100%

Upvotes: 0

Views: 63

Answers (1)

GalAbra
GalAbra

Reputation: 5148

Under Fields, Items & Sets click Calculated Field... and add your formula that's dependent on other columns in the Pivot table.

Example:

The database:

The Pivot table (with Field2 formula: = Revenue / Units):



Upvotes: 1

Related Questions