pivot table field settings % of...

C

Colin Funk

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top