+ Reply to Thread
Results 1 to 7 of 7

Arranging Pivot table data from Newest to oldest to Newest does not appear

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,238

    Arranging Pivot table data from Newest to oldest to Newest does not appear

    Dear Sir,

    Recently I have faced a problem with regard to Pivot Table in arranging data .I could not arrange or sort the the column K "Job Set Time" of sheet 1 which is composed of date and time. This I achieved in Sheet2 by copying and pasting the Pivot data.And then using filter.There comes the option "Sort oldest to Newest" in dropdown filter.But the same does option "Sort oldest to Newest" does not appear in the sheet 1. As I do have a lot of Pivot tables and in this way copying and pasting takes a lot of time.

    Is there any method of doing so.If so then kindly let me know.

    I have attached file.

    With Best Rgds

    suresh
    Attached Files Attached Files

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Arranging Pivot table data from Newest to oldest to Newest does not appear

    Hi,

    Please check the attached file and see if this is what you are looking for.




    Please click on ‘ * Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,238

    Re: Arranging Pivot table data from Newest to oldest to Newest does not appear

    Hi,

    Thanks for the reply.This you have done by copy paste.I am expecting to get arranged automatically and not by copy paste.I have a lot of Pivot tables like this.But I cannot go one by one like this doing copy paste as it is takes unnecessary time and unnecessary creating new sheet to get arranged.

    Hoping for a best solution in this forum.

  4. #4
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Arranging Pivot table data from Newest to oldest to Newest does not appear

    Hi,

    I had modified the pivot table to get the desired result & that was not a copy paste and sort.


    Please check.

  5. #5
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,238

    Re: Arranging Pivot table data from Newest to oldest to Newest does not appear

    Can you kindly let me know what are the steps and how you have done.

  6. #6
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Arranging Pivot table data from Newest to oldest to Newest does not appear

    Please move the "Job Set Time From" field to the beginning of the Row Labels since you want the Pivot table to be sorted based on this field. I have attached a snapshot showing where to change.
    Attached Images Attached Images

  7. #7
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,238

    Re: Arranging Pivot table data from Newest to oldest to Newest does not appear

    It means I have to simply move that column at beginning.And it will automatically get arranged.Is that so ?

    But one problem is here that I cannot change the position of that "Job Set Time From" from K to B as this is the reporting part to the boss where he does the analysis ?

    I think I have to move towards VBA forum.

    Any how thanks u have tried your best.

    With Best Rgds,


    PS
    If you know google docs spreadsheet,there one more challanging work in google spreadsheet.In excel it is very easy.If u r interested than I will send you the link.

+ 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. [SOLVED] Dates seem formatted correctly, but will not sort newest to oldest.
    By MelindaCapri in forum Excel General
    Replies: 6
    Last Post: 02-11-2015, 02:34 PM
  2. [SOLVED] VBA to sort columns left to right - oldest to newest
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-17-2013, 10:36 AM
  3. sorting a selected range by date, oldest to newest
    By zed commander in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-19-2012, 12:40 PM
  4. Top ten oldest and top ten newest
    By jhiltabidel in forum Excel General
    Replies: 11
    Last Post: 07-08-2011, 04:59 PM
  5. oldest to newest
    By Hidai in forum Excel General
    Replies: 5
    Last Post: 01-10-2011, 12:14 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