+ Reply to Thread
Results 1 to 5 of 5

How to filter a Pivot Table to the last 24 ours?

  1. #1
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    How to filter a Pivot Table to the last 24 ours?

    I made a nice looking production sheet so that every worker can see what happen in the last 24 ours. This sheet is for 24 ours of data only. The list of data is growing and i want to make see production sheet of days in the past.

    So i like the pivot the provide this sheet from data to filter only 24 ours from the start date en time in a cell.

    How can i filter a pivot table between two cells or 24 ours from 1 cell?

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: How to filter a Pivot Table to the last 24 ours?

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    Re: How to filter a Pivot Table to the last 24 ours?

    Underneath a example.
    Attached Files Attached Files

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: How to filter a Pivot Table to the last 24 ours?

    In the Datum Column, you can filter for multiple types of events. Click on the Drop Down Arrow and select Date Filters.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    Re: How to filter a Pivot Table to the last 24 ours?

    That is true, but i want to total block all options to prevent that someone remove thinks or changes the layout.
    Therefore i wil write a script that wil fill in de laste date -24 our. Or when double tap on de cell pop up a calendar so you can choose a begin date and then +24 ours as and date.
    To always have a chart of 24 ours so we can make a A3 papier with all the data from 24 ours of aan chosen date.

+ 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: 2
    Last Post: 04-24-2020, 04:56 AM
  2. Replies: 1
    Last Post: 02-25-2018, 09:47 PM
  3. Two pivot tables with the filter of pivot table 2 to automatically update to filter 1
    By StefaniaLa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2018, 06:19 PM
  4. Inserting filter into pivot table via macro errors if filter doesn't exist.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2018, 10:24 AM
  5. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  6. Pivot table, assigning a cell wo be change the Pivot table filter
    By jwongsf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2012, 05:00 PM
  7. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 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