+ Reply to Thread
Results 1 to 3 of 3

Row Label Filter Display with Excel Workbook

  1. #1
    Forum Contributor
    Join Date
    04-01-2019
    Location
    USA Ohio, Fremont
    MS-Off Ver
    Office 365
    Posts
    128

    Row Label Filter Display with Excel Workbook

    I would like to know if there is any way to automatically display the Row Label Filter similar to what is done for the Pivot Table filters.

    I have attached a Microsoft Excel Pivot Table practice file in which I have entered fictious employee names. I am a beginning Pivot Table user and this is my first Pivot Table, so please excuse if it is not set up for optimum use.

    If you open the Microsoft Excel Workbook and go to the Worksheet labeled Pivot-04 there is a Row Label Filter in cell C5 called Enter Time Minutes. This Row Label Filter selection is set to Between to display Enter Time Minutes is between 360 and 599. This is the equivalent of 6:00 AM and 9:59 AM.

    I am currently manually typing in this Row Filter Information in cell H5. This is the result I would like to achieve.

    I would like to have some way of automatically displaying this Row Label filter is this cell as there will be times, I want a different filter range.

    Currently the Pivot Table filters are shown automatically. See the following cells.

    1. UserNbrName Cell C9
    2. UserNbrName Filter Display Cell D9
    3. DoorNbrName Cell C10
    4. DoorNbrName Filter Display Cell D10
    5. Year Cell C11
    6. Year Filter Display Cell D11
    7. MonthNbr Cell C12
    8. Month Nbr Filter Display Cell D12

    I want the Row Filter Display to be similar to Cells D9, D10, D11, and D12. Desired Result.

    This way if I change the Row Filter Information it will be visible in a similar fashion.

    When I look at data, I want to know how it has been filtered.

    Any suggestions as to how I can do this would be appreciated.
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Row Label Filter Display with Excel Workbook

    duplicate
    https://www.excelforum.com/excel-cha...ml#post5786415

  3. #3
    Forum Contributor
    Join Date
    04-01-2019
    Location
    USA Ohio, Fremont
    MS-Off Ver
    Office 365
    Posts
    128

    Re: Row Label Filter Display with Excel Workbook

    Since I was unable to determine a way to display the Row Label Filter which I was asking to
    limit a field called EnterTimeMinutes between 360 minutes and 599 minutes (6:00 AM and 9:59 AM).
    I decided to take a different approach. I created a new column in my Pivot Table Excel Worksheet
    called EnterTimeRange. Since I am primary interested in filtering the Enter Time Information
    into five different ranges during a 24 hour day. The cells in the new column have a nested
    five IF formula shown below:

    IF(AND(U2>=1,U2<=359),"12:00 AM to 5:59 AM",
    IF(AND(U2>=360,U2<=599),"6:00 AM to 9:59 AM",
    IF(AND(U2>=600,U2<=839),"10:00 AM to 1:59 PM",
    IF(AND(U2>=840,U2<=1080),"2:00 PM to 6:00 PM",
    IF(AND(U2>=1081,U2<=1439),"6:01 PM to11:59 PM")))))

    Column U is the column where the Enter Time in Minutes field is located.
    I now have a means of displaying the Enter Time Range which is limiting the display of
    Enter Time Information in my Pivot Tables and Pivot Charts.
    See the filter information below which show on the Worksheet Pivot-04 on the
    attached Microsoft Excel Workbook.

    UserNbrName 1003-Wild Child
    EnterTimeRange 6:00 AM to 9:59 AM
    DoorNbrName 101-Front Door
    Year (All)
    MonthNbr (All)

    Granted this method does not give me the same flexibility as the Pivot Table Row Label filter but it will suffice for my means.
    If anyone knows how to simplify my nested IF statement let me know or point me to a link. It was very difficult for this Senior Citizen to create that formula.

    PS. I corrected some formula errors with my previous attachment to this thread.

    Thanks everyone for viewing and I appreciate all of the help I have received from this site
    in the past.
    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. Row Label Filter Display
    By TINHAMMER in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-01-2023, 03:21 PM
  2. [SOLVED] All Row Label doesn't display in Pivot ( Excel 2010 )
    By dineshsachidananda in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-18-2014, 10:10 PM
  3. Replies: 6
    Last Post: 01-07-2014, 03:24 PM
  4. to filter by criteria and calculate sum and display in next workbook
    By rshnkmr39 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2013, 01:25 PM
  5. Filter Pivot Table Row Label by Another Row Label
    By bdcelli in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-14-2013, 12:57 PM
  6. Display an excel box in a vba label
    By kieranbop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2011, 03:57 AM
  7. Excel 2003 does not display all of plot y axis label. What's up?
    By byrdman in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-14-2005, 06:30 PM

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