i dont have power pivot an my mac vesion
@TMS suggested using in column C A2+0
then if you Copy C
and use a Paste Special > value into column A
now column A is setup as a date
Now the pivot table will order by date , as my example
The logic is that you need dates , in order to sort by the date , otherwise if text , it will sort alphabetically and not in date order
did my example spreadsheet actually give you want you wanted ?
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank you! Yes, It did help.
then if you Copy C
and use a Paste Special > value into column A
now column A is setup as a date
I can't replicate the above steps. I haven't used it before.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Jigneshbharati 
Register To Reply
Bookmarks