Results 1 to 3 of 3

Cumulative Frequency Table and Pivot Table

Threaded View

ryue65 Cumulative Frequency Table... 12-09-2009, 08:09 PM
JeanRage Re: Cumulative Frequency... 12-10-2009, 03:09 AM
ryue65 Re: Cumulative Frequency... 12-10-2009, 04:50 PM
  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.

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