+ Reply to Thread
Results 1 to 8 of 8

ISO Help with Running Total in...

  1. #1
    Registered User
    Join Date
    02-11-2019
    Location
    NY
    MS-Off Ver
    Office 365
    Posts
    3

    ISO Help with Running Total in...

    Attached file has 2 sheets:
    - dataset in first sheet only has a few columns, and pivot running is calculated correctly

    - dataset in 2nd sheet has additional columns, and pivot running is not correct; column T shows what i expect the values to be

    Thank you for your time and assistance
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: ISO Help with Running Total in...

    Is this OK??

    =SORTBY(A2:C13,A2:A13,1,C2:C13,1)
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    02-11-2019
    Location
    NY
    MS-Off Ver
    Office 365
    Posts
    3

    Re: ISO Help with Running Total in...

    Thank you Glenn,
    I'm not sure where you put the SortBy
    and the Running Per Week is not showing the correct answers

    I have the correct answers in Column T

    Within in Week, the rows can be sorted either by TX_date or ID

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: ISO Help with Running Total in...

    Ooops. V2. It is in the THIS WORKS sheet.

    =LET(A,SORTBY(A2:C13,A2:A13,1,C2:C13,1),B,MMULT((SEQUENCE(ROWS(A))>=SEQUENCE(,ROWS(A)))*(INDEX(A,,1)=TRANSPOSE(INDEX(A,,1))),N(+INDEX(A,,3))),CHOOSECOLS(HSTACK(A,B),1,2,4))
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-11-2019
    Location
    NY
    MS-Off Ver
    Office 365
    Posts
    3

    Re: ISO Help with Running Total in...

    Thank you Glenn, but the file you are sending me has the same wrong info in Column R as my original file.

    It should have the figures that I have hard-coded in Column T

    Also, I'm not seeing your formula in the workbook, nor do I know where to put it....


    Thank you for your help - I'm going to send the file to our accountant; they have an excel pro on staff.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: ISO Help with Running Total in...

    It's hard to miss, I think!!
    Attached Images Attached Images

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: ISO Help with Running Total in...

    If incorrect, post a file showing ONLY the data you want to work with and a mock-up of the expected results. DO NOT confuse things by showing 2 sets of raw data.

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: ISO Help with Running Total in...

    I think I understand now. So, I have replaced your Pivot Table with a dyanmic array formula that does the lot, dynamically, in one Excel cell. Of the displayed columns, are there ANY that you wish not to display?

    Nothing much needs to be adjusted - just the Table name at the start.. It's also alive... it will update automatically.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you don't like it... I don't mind too much, as I've learned a lot playing with it!!
    Attached Files Attached Files

+ 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: 4
    Last Post: 04-26-2021, 11:13 AM
  2. How to calculate running total + total remaining in a pivot?
    By Traste in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-03-2017, 10:41 AM
  3. Running total after payments running total on excel
    By tmagplayr in forum Excel General
    Replies: 7
    Last Post: 09-26-2017, 02:01 PM
  4. Replies: 8
    Last Post: 07-19-2017, 12:06 PM
  5. [SOLVED] Running total from a daliy worksheet into a montly total.
    By jakesib in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-15-2014, 10:49 PM
  6. Pivot Chart Running Total - Removing Current Year Future Total
    By car3489 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-27-2013, 03:35 AM
  7. [SOLVED] % of Running Total to Grand Total in Pivot Table
    By David in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2005, 04: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