Thread: Pivots - Auto calc % Sub total is of grand total
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
VBA Noob VBA Noob is offline
external usenet poster
  
Posts: 1
Default Pivots - Auto calc % Sub total is of grand total

Hi,

Is it possible in a pivot to take the subtotal lines

e.g Customer 1 total is £35.60 and work out what % this is of the Grand
total. In this Example

Customer 1 would be 9%
Customer 2 would be 68%
Customer 3 would be 23%

Customer summary ¦Yr 2006
Customer 1 Total ¦£35.60
Customer 2 Total ¦£261.50
Customer 3 Total ¦£87.60
Grand Total ¦£384.70

PS Trying to avoid paste special values and entering formulas manually

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569364

Reply With QuoteReply With Quote