+ Reply to Thread
Results 1 to 2 of 2

Cannot Create a Running Total, Calculated Field in a Pivot table

  1. #1
    Registered User
    Join Date
    08-28-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    9

    Cannot Create a Running Total, Calculated Field in a Pivot table

    Hey guys,

    Thanks for your time. My problem is that I cannot figure out how to create a "running total" calculated field in an Excel pivot table. It is a large table and two of the columns are [Cost] and [Date]. I would like to create a calculated field that is a running total of my [Cost] column based on the date. Does anyone know how to do this?

    Additional info:

    This pivot table is being pulled in through a data connection, not a table so adding a new [running total] column to a table and then adjusting the range of the pivot table is not an option.

    Side note- i am assuming there is a way to easily do this in excel (which I would prefer) but for those of you guys (or girls) who know SQL I am not opposed to adding a line of code to create a new column there for [Running total] if you know how to do that instead

    --
    JD

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Cannot Create a Running Total, Calculated Field in a Pivot table

    HI JD,

    May be below thread can guide you ..

    http://www.excelforum.com/excel-char...-together.html

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ 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