View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
steven1001
 
Posts: n/a
Default Pivot Tbl Calc Field using %'s


Try creating a helper column for the margin$ and then use a Calculated
Field to calculate the % as Margin$/Cost$ (or whatever you need to do
to get the correct%)

regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=528399