View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Charlie Bamford Charlie Bamford is offline
external usenet poster
 
Posts: 6
Default Pivot Table Running Sum %



"Herbert Seidenberg" wrote:

Add helper column to source data:
http://www.freefilehosting.net/download/3e4gm
Thanks for this. I got this far myself but what I'd like to see is the cumulative percentage i.e. values 51.4%, 70.5%, 82.1% going down the % column. This will enable me to quickly see that the top 20 products account for 80% of the sales.

Regards