calculated field

[isacp]

how do i make a calculated field?
help please!
i need to have two columns devided one by the other to come up with a %
in a pivot table.
but i also need the total not to add the % up but to be deviding the total of the other columns
ie. i need coulm n/i all the way threw including the total row

 

[Norie]

Do you really need a calculated field to do this?

There are several options in Field Settings to display items as % ot totals etc.