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. 

 

Help?!

11replies 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
  • I am experiencing a similar issue as it relates to sorting pivot tables; I can sort within editing (switch from ascending to descending), but I don't see a way to have it save this way so that my embedded reports (pivot tables) show with the sorting that I prefer.

    Reply Like
  • Hi  Karen Gonyea ,

     

    Thanks for your response! We do not currently have a way for the sorting that you apply to the pivot table in the chart editor page to persist to the report view page. The report viewer basically will have to indicate their desired sorting by interacting with the pivot table on the report view page. Happy to add this as a feature request though! Let me know if you have any further questions at all!

    Reply Like
  • It seems fairly clear that the pivot tables are really basic. I haven't been able to use them in any situation because they are so limiting. The beauty of a pivot table in other platforms are there versatility. It seems strange to offer such a poor version as one of the charting options

    Reply Like
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 11Replies
  • 961Views
  • 8 Following

Create A New Discussion

Share your thoughts