LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to change field settings in calculated field in a pivot tab Mike Excel Discussion (Misc queries) 0 September 25th 06 07:45 PM
Permanent change of Field Settings in Pivot Table Sue Sch Excel Discussion (Misc queries) 1 July 21st 06 05:05 AM
Excel pivot table field settings kyfriedchipper Excel Worksheet Functions 2 May 18th 06 04:12 AM
Pivot Table Field Settings Default value MMesarch Excel Discussion (Misc queries) 2 November 2nd 05 09:50 PM
Pivot Table Field Settings Pivot Novice Excel Worksheet Functions 5 July 13th 05 01:40 AM


All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"