Thread: How do I generate and subtotal percentages of data in a pivot tabl
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
steven1001
 
Posts: n/a
Default How do I generate and subtotal percentages of data in a pivot tabl

You could try using the function on the Field which lets you display as
a %.
Right click on the value, select Field Settings, Options, Show Data
As.
Then you get a range of choices.
Regards..


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

Reply With QuoteReply With Quote