+ Reply to Thread
Results 1 to 3 of 3

PowerPivot - Sort by column working in Powerpivot, but not actual pivot table

  1. #1
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    PowerPivot - Sort by column working in Powerpivot, but not actual pivot table

    Hello All
    I have brought a column into my pivot table from the calendar table, with this format: "W/E - Feb 08", "W/E - Mar 08", etc....
    Obviously this won't be sorted correctly if it is sorted alphabetically, so i also brought in a week # column, and sorted my "W/E" column based on the "Week #" column".
    In Powerpivot, this worked perfectly. If i sort based off of that column, it does Feb, then Mar, then Apr.
    BUT.... If I switch to my pivot table, it is not updating how it is sorted.

    Update: If I make a NEW pivot table, it will sort correctly. but the existing pivot table will not. even if I remove the field, and add it back in, it won't sort correctly.
    Really frustrating, as I don't want to make this pivot table from scratch, and recreate the graph I have made, but... doesn't seem to be another way. If anyone else knows a way of refreshing the sort of this column in the pivot table without creating a new pivot table, please let me know. Refreshing the pivot table also did not help, so.... not sure what else to try.
    Please click the * icon below if I have helped.

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13
    Posts
    953

    Re: PowerPivot - Sort by column working in Powerpivot, but not actual pivot table

    Hi Melvinrobb,

    Can you post the file for testing?

    Thanks
    Remember you are unique, like everyone else

  3. #3
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: PowerPivot - Sort by column working in Powerpivot, but not actual pivot table

    Unfortunately that won't be possible, because of the data sensitivity.
    It would also take quite a while to reproduce the scenario with mock data, and I am not confident I could reproduce the error.
    This time, I just went ahead and made a new pivot table and graphs.
    I will just need to see what happens the next time I try this sort, and if the same issue occurs, I may have to bring up this issue again, and go to the work of making a mock workbook.

+ 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. Powerpivot Calculated Measure to remove blanks from pivot table/chart
    By hbusche in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-17-2013, 01:23 PM
  2. Replies: 0
    Last Post: 11-20-2012, 05:34 AM
  3. Replies: 0
    Last Post: 06-22-2012, 07:13 AM
  4. Replies: 1
    Last Post: 11-29-2011, 10:52 PM
  5. Pivot table missing rows using PowerPivot
    By djgfx in forum Excel General
    Replies: 1
    Last Post: 04-06-2011, 01:16 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