+ Reply to Thread
Results 1 to 3 of 3

Pivot Table: Calculated Field based on Running Total Field

  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

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: Pivot Table: Calculated Field based on Running Total Field

    Hi EvolvingMonkey,

    It would be better if you post a file with your data, I can't copy your attachments & paste into Excel.

    Also, I need to understand how your 'Running Totals' update if they come from 'the data'?

    To answer what you've asked, it seems that everything will work based on your 'Running Totals' updating, can you show in your posted file how it works.
    Remember you are unique, like everyone else

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Pivot Table: Calculated Field based on Running Total Field

    Hi,

    Do you have Power Pivot available with your version of Excel 2013?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. 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. [SOLVED] 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