View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Funk Colin Funk is offline
external usenet poster
 
Posts: 1
Default pivot table field settings % of...

i want to calculate an item as a percentage of another item in the same row
of a pivot table...i have the following PT columns & rows

col a col b col c
state net rev cost

ca $1.00 $0.50

i want to show the cost as a percentage of the net rev without having to
create calculated fields...i htought that maybe the field seting sho data as
% of would work but can not seem to get the result i want...help!