+ Reply to Thread
Results 1 to 3 of 3

Cumulative Frequency Table and Pivot Table

  1. #1
    Registered User
    Join Date
    12-09-2009
    Location
    dublin,ireland
    MS-Off Ver
    2010
    Posts
    4

    Unhappy Cumulative Frequency Table and Pivot Table

    Hi
    Is it possible to create a cumulative frequency table with Pivot Tables?
    e.g I have a set of data summarised into 5 segments with units #

    I can use the pivot table options to produce the 2nd column (% of Total in Column) or 3rd Column ( running total) but I cannot find a way to get the 4th column ( cumulative % running total ?)


    data# %total run to ***%
    a 40 40% 40 40%
    b 20 20% 60 60%
    c 30 30% 90 90%
    d 5 5% 95 95%
    e 5
    5% 100 100%


    I want to be able to use the data to produce charts without having to copy and paste data to create seperate charts.
    Last edited by ryue65; 12-10-2009 at 04:47 PM.

  2. #2
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Cumulative Frequency Table and Pivot Table

    Hi,

    Yes, it is feasible with a running total ...

    See Debra's solution

    http://www.contextures.com/xlPivot10.html#Running

    HTH

  3. #3
    Registered User
    Join Date
    12-09-2009
    Location
    dublin,ireland
    MS-Off Ver
    2010
    Posts
    4

    Re: Cumulative Frequency Table and Pivot Table

    Hi JeanRage
    I qualified the question based on your feedback.

    I would like to use a combination of running total and % of column to get a cumulative % total. This will be used to plot a cumulative % plot

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1