+ Reply to Thread
Results 1 to 5 of 5

How to filter the highest data for each row in a pivot table?

  1. #1
    Registered User
    Join Date
    11-07-2020
    Location
    Copenhague
    MS-Off Ver
    Microsoft office 365
    Posts
    99

    How to filter the highest data for each row in a pivot table?

    Good morning community!
    I would like to find the highest value for each row in the following pivot table (ex: the yellow is the highest value for each row and i want to do this for the entire pivot table)
    How to do it? Please find my worksheet "Template 6" and the pivot table in the sheet "GD".
    Template (6).xlsm

    Thank you for your help!
    Attached Images Attached Images
    Last edited by Luu4466; 11-26-2020 at 05:32 AM.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,040

    Re: How to filter the highest data for each row in a pivot table?

    Select columns N to Q - with N1 as the activecell - and use CF with the formula option, and the formula

    =AND(N1<>"",N1=MAX($N1:$Q1))

    and choose your yellow fill.

    Note that this does not break ties but will highlight both - your example file has a few rows like that.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    11-07-2020
    Location
    Copenhague
    MS-Off Ver
    Microsoft office 365
    Posts
    99

    Re: How to filter the highest data for each row in a pivot table?

    Thank you for your answer. What do you mean by CF? I don't know what is it.

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,040

    Re: How to filter the highest data for each row in a pivot table?

    Sorry - CF is Conditional Formatting. It is on the Home ribbon. Click it and choose "New rule...." then "Use a formula to determine which cells to format" and the formula I posted.

  5. #5
    Registered User
    Join Date
    11-07-2020
    Location
    Copenhague
    MS-Off Ver
    Microsoft office 365
    Posts
    99

    Re: How to filter the highest data for each row in a pivot table?

    Thank you for your reply. It's really clear now.

+ 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. Filter Pivot Table with Data in the Pivot Table
    By lxy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-25-2020, 11:57 AM
  2. Replies: 0
    Last Post: 03-22-2020, 10:58 PM
  3. Replies: 3
    Last Post: 07-12-2019, 06:17 AM
  4. Filter Pivot Table Data
    By carlberg44 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-25-2019, 09:31 AM
  5. Pivot table filter not changing data in table - Using macro
    By DJDRU in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-09-2016, 06:16 AM
  6. [SOLVED] Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank
    By vinaynaran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2016, 08:47 AM
  7. Data filter in Pivot table
    By anandmr65 in forum Excel General
    Replies: 1
    Last Post: 09-27-2006, 09:21 AM

Tags for this Thread

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