+ Reply to Thread
Results 1 to 4 of 4

Displaying only the max of one field for a specific row label in pivot table?

  1. #1
    Registered User
    Join Date
    12-02-2019
    Location
    USA, Kentucky
    MS-Off Ver
    2007
    Posts
    2

    Question Displaying only the max of one field for a specific row label in pivot table?

    Trying to sort training records within a pivot table. For each Procedure being trained an employee potentially could be trained on multiple revisions of the procedure. All would be documented by the revision level being trained on and the date of training. What I want to show in a pivot table is only the highest revision level trained.

    Example with fictitious names.
    John Smith trained on SOP 7.5.501 revision levels 1 through 6. Would like his record to show only Rev 6
    Jackalynn Brown trained on SOP 7.5.500 revision levels 1 through 3. Would like her record to show only Rev 3

    Of course the rest of the employees would be listed similarly with only the highest Rev level trained shown. Struggling a bit with filters, etc. My skill level to date has not been in writing script, etc.

    Any help would be appreciated. File attached.
    Dennis
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    8,282

    Re: Displaying only the max of one field for a specific row label in pivot table?

    Hello DMC62 and Welcome to Excel Forum.
    For the sample data given the following seems to work.
    1. Move both the level and date to the 'Values' field.
    2. For both the level and date choose the field setting 'Max'.
    3. For date choose number format date
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    12-02-2019
    Location
    USA, Kentucky
    MS-Off Ver
    2007
    Posts
    2

    Re: Displaying only the max of one field for a specific row label in pivot table?

    Thank you. This helps me out. I see how that woks for this now.

    Kind regards,

    Dennis
    Last edited by DMC62; Yesterday at 03:16 PM.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    8,282

    Re: Displaying only the max of one field for a specific row label in pivot table?

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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