+ Reply to Thread
Results 1 to 3 of 3

SOLVED - Cumulative Sum in Pivot tables

  1. #1
    Registered User
    Join Date
    10-31-2019
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    16

    Question SOLVED - Cumulative Sum in Pivot tables

    Hi - hope someone can help!
    I have a lovely pivot table showing various sums by date, but I want to make these cumulative.
    I have tried using the Running Total In option, but I'm still just getting actual values each month, not the cumulative amount. I[ve tried switching it from Budget/Actual field to Category field, still no cumulative total.
    Where am I going wrong?
    Attaching a sample workbook - the data set has been culled to only provide data for the specific project - normally there are hundreds of projects and 20k+ rows of data!
    Many thanks in advance
    Attached Files Attached Files
    Last edited by LesleyB ATL; 08-05-2020 at 05:53 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Cumulative Sum in Pivot tables

    In green the running totals.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    10-31-2019
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    16

    Thumbs up Re: Cumulative Sum in Pivot tables

    Many thanks oeldere
    Its not exactly what I wanted, but your example, switching the columns and rows around, helped me to work it out and get it how I wanted it.
    Million thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating a Master / Consolidated Pivot Tables from a multiple pivot tables
    By paradise2sr in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-12-2013, 02:28 AM
  2. Creating a Master / Consolidated Pivot Tables from a multiple pivot tables
    By paradise2sr in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-08-2013, 10:49 PM
  3. Pivot Tables - need to do separate pivot tables for multiple sheets in same format
    By tconnell1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 07:04 AM
  4. Replies: 0
    Last Post: 09-22-2012, 07:22 PM
  5. Excel 2007 : cumulative percentages in pivot tables
    By kogliostro in forum Excel General
    Replies: 0
    Last Post: 04-12-2011, 03:52 PM
  6. Cumulative Sums in Pivot Tables
    By Laura in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-11-2006, 02:00 PM
  7. Pivot Tables Cumulative Percentages
    By SASMAN in forum Excel General
    Replies: 0
    Last Post: 07-25-2005, 10:05 PM

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