try this. copy down
=G1/SUM($G$1:$G$4)

--
Don Guillett
SalesAid Software

"RoryMacLeod" wrote in message
...
Have a PT like this:

Month Who
Jan 3.5
Feb 2.2
Mar 3.3
Total 9.0

I want to add a new custom field or whatever on the right of this that
will
show each item as a percentage of the total so I see 2.2 and 25% next to
it.

Thanks
Rory