Results 1 to 13 of 13

Dates Not Sorting Correctly in Pivot Table

Threaded View

  1. #1
    Registered User
    Join Date
    03-28-2014
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Dates Not Sorting Correctly in Pivot Table

    Here is how my Pivot Table is set up.

    \1
    \1
    \1

    The way my dates are derived in the source data comes from an equation that converts the UNIX timestamp in Column C to PST.

    =IF(ISBLANK(C2),"",(C2/86400)+25569+($H$1/24))

    When I group by day, and attempt to sort, it changes the date format and will not sort correctly. Any ideas here?
    Attached Images Attached Images
    Last edited by eightythree; 04-13-2014 at 02:24 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sorting Dates in a Pivot Table is not working
    By Excel_vba in forum Excel General
    Replies: 1
    Last Post: 10-09-2012, 02:31 PM
  2. Sorting dates in Pivot table
    By scuba2x2 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-13-2012, 07:45 PM
  3. Sorting Dates in a Pivot Table
    By johncassell in forum Excel General
    Replies: 1
    Last Post: 07-11-2011, 06:31 AM
  4. Pivot table no longer sorting correctly (2003)
    By mlk in forum Excel General
    Replies: 0
    Last Post: 02-28-2011, 02:15 PM
  5. Pivot Table not sorting correctly
    By Marian in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-28-2006, 12:20 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