Sorting broken in pivot tables?

Created a pivot table

1st. Column has text

2nd and 3rd Column is numbers

Report is sorted alphabetically by the first column. 

Sort by 2nd column, descending, no change to the search order

Change the format to "numbers"

No change. 



8replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hey Bart , I believe the product is behaving as intended for nested headers. If you have multiple fields applied to the Rows/Columns quadrant, the way we do sorting in nested headers is by grouping: if you choose to sort values in a field down in the tree, those values will only sort within the grouped-by branch higher up the tree, which is by design. Let me know if you have any questions/concerns about this!

    Reply Like
  • That's odd. Why would the option to sort the columns be there if it doesn't work?

    Reply Like
  • Bart Myers  They still work, but only in the context of the nested columns. I do understand the confusion though, and I'll chat with the product team to see if we can make this a bit clearer.

    Reply Like
  • Another related issue - We have created a pivot table with a date column as the first column. It defaults to ascending. I can't reverse it to descending. It won't save the sort. 

    Reply Like
  • Hey Bart , when you say "it won't save the sort", are you referring to when you sort the column in the pivot table editor, it won't persist when you go to the report builder? 

    Reply Like
  • Hi there, similar question / request. I'd like to be able to sort based on the numbers column at the end of the pivot table. Instead, I'm only able to sort alphabetically by the first field (I've noticed Mode seems to like sorting alphabetically 🙂).

    Any assistance in sorting by the Totals column as shown below would be greatly appreciated. Thanks!


    Reply Like 1
  • Hi Greg !  Mode Pivot Tables can't sort by the totals column at the moment.  We've had requests to allow pivot tables to sort by the total column so it is being considered.  I'll make sure we notify you when this feature becomes available.  Thanks!

    Reply Like 3
  • Donna McGahan Any update on the ability to sort by totals column?

    Reply Like
reply to topic
Like Follow
  • 2 wk agoLast active
  • 8Replies
  • 723Views
  • 5 Following

Create A New Discussion

Share your thoughts