Results 1 to 3 of 3

Pivot Table: Calculated Field based on Running Total Field

Threaded View

  1. #1
    Registered User
    Join Date
    09-06-2016
    Location
    Missouri, USA
    MS-Off Ver
    2013
    Posts
    1

    Pivot Table: Calculated Field based on Running Total Field

    So I've been searching for a while this morning with no luck so far - I'm not even sure it is possible to do what I am trying to do....

    I have a Pivot table similar to the following:
    Snap2.png

    Widget, X, Y & X/Y come from the data

    X(RunTotal) & Y(RunTotal) are simply X & Y, shown as Running Totals

    X/Y (RunTotal) (orange column) needs to be "X(RunTotal) divided by Y(RunTotal)" at each row (as I have in the image)....but it's coming back as the same as X/Y since X(RunTotal) and Y(RunTotal) are just running total fields of X & Y.

    I'm wanting this in a pivot table because I'm using a pivot chart with slicers to let users dynamically filter the data. Outside of a pivot it's easy...inside of one, I'm coming up short.

    Any help??? Is this even possible?

    Thanks!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 08-15-2016, 02:07 PM
  2. Replies: 1
    Last Post: 12-10-2012, 05:41 AM
  3. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  4. Replies: 2
    Last Post: 04-14-2011, 09:33 AM
  5. Using '% of Total' in calculated field in Pivot Table
    By goofy11 in forum Excel General
    Replies: 2
    Last Post: 05-09-2006, 06:35 PM
  6. [SOLVED] Missing Grand Total for a Calculated Field in a Pivot Table
    By Robert Hamilton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2006, 02:20 PM
  7. [SOLVED] Pivot Table Calculated Field (Grand total question)
    By Linda in forum Excel General
    Replies: 5
    Last Post: 08-03-2005, 06: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