+ Reply to Thread
Results 1 to 4 of 4

How to Sum the Max values in a Pivot

  1. #1
    Registered User
    Join Date
    03-06-2024
    Location
    Canada
    MS-Off Ver
    365 Excel
    Posts
    2

    How to Sum the Max values in a Pivot

    Hello all, I'm hoping someone will be able to give me a hand with this.

    I'm trying to get the Sum of the Max values in a Pivot, the problem is the underlying data, and thus the Pivot, will be frequently updated and a variable size so I can't just select a specific range to Sum.

    My example has a very small chunk of what the data looks like, and the pivot I put together that gets me as close as I can to the result I want.

    The solution I'd be looking for would look like the highlighted cells in N, which from there I can calculate the number of order lines a user picks in an hour.

    I'm open to any kind of solution, the data is just copy/pasted in from another source so it can be manipulated if need be.

    Appreciate any help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: How to Sum the Max values in a Pivot

    If you really sum each instance of the same time you will different numbers than what you pointed.
    I created a new column in the PT to sum, but it sum it all, including the equal time.
    Attached Files Attached Files

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: How to Sum the Max values in a Pivot

    You can use Power Pivot and the data model to get what you want. See attached with new pivot below your original one.
    Attached Files Attached Files
    Rory

  4. #4
    Registered User
    Join Date
    03-06-2024
    Location
    Canada
    MS-Off Ver
    365 Excel
    Posts
    2

    Re: How to Sum the Max values in a Pivot

    That's perfect, thank you! Simple and efficient. I've never used Power Pivot before, definitely going to try it out going forward.

    Cheers!

+ 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. [SOLVED] How to connect date values with month values? and make a summary pivot table?
    By Hasnat124 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-28-2023, 11:00 AM
  2. Replies: 4
    Last Post: 07-01-2020, 02:13 AM
  3. [SOLVED] filtering a pivot chart / pivot table on x-axis values
    By Trebor777 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-20-2016, 01:28 PM
  4. Replies: 2
    Last Post: 12-18-2016, 08:37 PM
  5. Format a pivot table based on values of a pivot column
    By chytechplus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2016, 06:32 AM
  6. switch values of a pivot data fields using cell values (function and attribute)?
    By Shmulik_r in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2013, 02:36 PM
  7. Replies: 11
    Last Post: 09-10-2008, 01:27 AM

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