+ Reply to Thread
Results 1 to 4 of 4

Running total on percentages in Pivot table

  1. #1
    Registered User
    Join Date
    08-31-2010
    Location
    Paris, France
    MS-Off Ver
    Excel 2010
    Posts
    11

    Running total on percentages in Pivot table

    TCDEN.jpg

    Hi,
    I have an external data source with some text fields, a month field, and two numeric fields :
    • New customers per month
    • New customer target per month.

    I can get the external data connected to the spreadsheet and I know how to make Pivot tables.
    What I can't manage is the running total of the monthly percentages as shown in the attached file TCEN.jpg.

    (The picture is a fake PT. just to illustrate what I want to do but can't.)

    Any help appreciated especially if it
    • does not involve modifying the external data and
    • does not involve VBA.

    TIA,
    Wayne
    Last edited by Wayne Dunlop; 09-11-2012 at 09:06 AM.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Running total on percentages in Pivot table

    Use..

    =SUM($C2:C2) and drag across and down

    See attached. Also, going forward please upload a worksheet if you want a spreadsheet solution
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    08-31-2010
    Location
    Paris, France
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Running total on percentages in Pivot table

    I think I posted my original question in the Pivot Table section.
    I don't think I can paste SUM formula into a Pivot table as you suggest.
    Thanks all the same.

  4. #4
    Registered User
    Join Date
    08-31-2010
    Location
    Paris, France
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Running total on percentages in Pivot table

    I have moved this thread to the "General" section.
    I will try to remove it from here.
    Wayne

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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