+ Reply to Thread
Results 1 to 2 of 2

In pivot table, can we see the data match the choose max value?

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    In pivot table, can we see the data match the choose max value?

    Hi experts, hope you are having a good day.

    I have two questions about Pivot table:

    1. I have found the max value for Monday to Friday hourly value in the hourly data. can I have a quick field to show the exact date and time when the max value occurred? Seems I could use the lookup etc to work on those, just wonder if there is any quick way to get it.

    Data sample: A-date B-time C-weekday D-visitors
    Pivot table: A-Monday B-max of visitors C-date? D time?

    2. can I calculate each value/max of a range of value within Pivot table. I can't seem to use the "calculated item". Any ideas?

    Pivot table: B1-09:00 C1-10: 00 D1-11:00 etc
    A2- monday B2-50 C2-79 D2-100
    A3 -%/max of the day

  2. #2
    Forum Contributor
    Join Date
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019

    Re: In pivot table, can we see the data match the choose max value?

    Instead of choosing MAX, why not just show the actual value, and sort max to min, and then the top value will show the data you want?

+ 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: 06-27-2020, 06:00 AM
  2. Replies: 2
    Last Post: 01-29-2018, 02:51 AM
  3. Replies: 4
    Last Post: 09-11-2013, 10:22 AM
  4. Choose account managers from pivot table
    By ronlau123 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-14-2011, 11:07 AM
  5. If dates match, then insert data from pivot table
    By Chookz in forum Excel General
    Replies: 1
    Last Post: 05-09-2011, 02:56 AM
  6. Replies: 4
    Last Post: 10-06-2008, 12:15 PM
  7. Replies: 2
    Last Post: 09-12-2005, 03:05 PM


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