Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Cummulative Sum in Pivot Table

I have a pivot table and I am able to count number of orders within certain
dollar band. Below is an example.

Dollar Band # orders Cumm %
<100 10 20%
101-200 20 60%
201-300 10 80%
300 10 100%


How can I create the cummulative % next to the # orders column within the
pivot table?


Reply
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
how to create pivot table from existing pivot table in excel 2007 Udayraj Dhulekar Excel Discussion (Misc queries) 2 July 8th 13 08:22 PM
How do I calculate "cummulative percent of total" in a pivot table Steve P Excel Discussion (Misc queries) 0 September 25th 07 02:06 PM
Cummulative tjh Excel Worksheet Functions 2 February 13th 07 10:55 PM
cummulative sum chiapas77 Excel Worksheet Functions 3 January 17th 06 06:48 PM


All times are GMT +1. The time now is 11:08 AM.

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

About Us

"It's about Microsoft Excel"