Pivot Table not Sorting Dates Correctly HELP!
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Pivot Table not Sorting Dates Correctly HELP!

  1. #1
    Board Regular CDICKENS's Avatar
    Join Date
    Mar 2002
    Location
    Tarheel State
    Posts
    498
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a daily sales report for different product types in excel. I am using a pivot table to calculate the data. Twice since the first of the year after adding new sales and refreshing the pivot table, the "new" dates are not in chronological order. This messes up my formula for displaying the information in my report. I have to reassign which cells in the pivot table my report should be looking at.

    Is there a better way to set up this report or another way to sort the pivot table?

    Thanks,

    Chuck

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Leiden, The Netherlands
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you tried this?
    Double click the date header in the pivot table and click the "Advanced..." button. Select the "Ascending" options on Autosort Options and choose the field you want to sort on.

    Marc

  3. #3
    Board Regular CDICKENS's Avatar
    Join Date
    Mar 2002
    Location
    Tarheel State
    Posts
    498
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    That appeared to work...

    except one date did not fall back in line. I can live with that.

    THanks
    CHuck

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com