Pivot Tables Incorrectly Sorting Dates
Hi Everyone,
I'm having an issue with my pivot tables. The date range is from November 2015 - April 2016. However, when I sort by date, it puts January on top. This error (likely my own misunderstanding) disrupts graphs, as it assumes January 2016 comes before Nov. 2015.
Any help is appreciated.
Picture1.png
It would help if you post a sample of you spreadsheet. Remove any sensitive data you don't want to share with the public.
My best guess is you need to add the year to your date and adjust how Excel displays the date using custom date formatting. But I'm just guessing without a sample of your data.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks