+ Reply to Thread
Results 1 to 3 of 3

How to show all dates in one column and time intervals + count in a pivot table?

  1. #1
    Registered User
    Join Date
    06-18-2020
    Location
    Arizona
    MS-Off Ver
    Office 365
    Posts
    68

    How to show all dates in one column and time intervals + count in a pivot table?

    To better explain the title, I am trying to transform a pivot table to show the following screenshots as an example. I've also attached the file. Is this possible?

    Capture.JPG

    To look like this but also in pivot table form:

    capture2.jpg
    Attached Files Attached Files
    Last edited by cph020283; 06-02-2021 at 07:45 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,492

    Re: How to show all dates in one column and time intervals + count in a pivot table?

    If I am understanding correctly, then this Power Query Solution should work for you

    Please Login or Register  to view this content.
    Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

    It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

    - Follow this link to learn how to install Power Query in Excel 2010 / 2013.

    - Follow this link for an introduction to Power Query functionality.

    - Follow this link for a video which demonstrates how to use Power Query code provided.
    Attached Files Attached Files
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    06-18-2020
    Location
    Arizona
    MS-Off Ver
    Office 365
    Posts
    68

    Re: How to show all dates in one column and time intervals + count in a pivot table?

    This was a great help, thank you!
    Last edited by cph020283; 06-02-2021 at 07:45 PM.

+ 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. How to show individual dates in a pivot table
    By Ayupchap in forum Excel General
    Replies: 4
    Last Post: 05-06-2021, 06:06 PM
  2. Show value instead of count or sum in Pivot Table
    By samot79 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-21-2017, 05:29 PM
  3. Pivot table show dates instead of sum in value
    By cabry in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-03-2014, 01:29 AM
  4. Replies: 3
    Last Post: 04-17-2014, 09:50 PM
  5. Make dates not show in Pivot Table
    By Lynn McCurdy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2011, 01:36 AM
  6. Replies: 1
    Last Post: 02-09-2010, 06:16 PM
  7. Pivot Table Filters always show as dates
    By smninos in forum Excel General
    Replies: 2
    Last Post: 12-03-2009, 03:01 PM

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