+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Not Sorting Time Period in Chronological Order

  1. 08-13-2018, 06:48 PM #1
    evarjas
    evarjas is offline
    Registered User
    Join Date
    08-13-2018
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    1

    Pivot Table Not Sorting Time Period in Chronological Order

    I need help with my Pivot Table. The time periods are not showing up in chronological order. I have attached my Excel spreadsheet for reference.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-13-2018, 10:17 PM #2
    kersplash
    kersplash is offline
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Pivot Table Not Sorting Time Period in Chronological Order

    Because your dates are text within a field of text.

    You'll need to extract the date out of the Time field.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Index-match or Pivot table 1 name shows everything they did for the day in time order
    By justinwb in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-07-2017, 03:58 AM
  2. [SOLVED] Chronological Ordering Of Time Periods In Pivot Table
    By bkahl34 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-24-2017, 05:25 PM
  3. [SOLVED] Pivot Table : Planned and Actual Count Over Same Time Period
    By chullan88 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 02-11-2016, 12:44 AM
  4. Timesheet -> Pivot table showing % of hours by job type over a period of time
    By TheTallBloke in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-03-2015, 07:31 AM
  5. Pivot Table and Sorting Data at one time.
    By rakesh2806 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-22-2013, 12:51 AM
  6. obtain chronological order without sorting
    By Diamant in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-21-2012, 12:18 AM
  7. 2010 Pivot Table Sorting The Same Order As Data Source
    By Nunzio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2012, 05:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1