Jump to content

Is there a way to sort multiple columns in a cross table like you can do with custom sort in excel

Amy Scragg

Recommended Posts

In a Cross Table, you can choose only single column to sort here:


Properties > Sorting > Sort rows by


Whereas the Table visualization allows multiple column sorting.

So there is really only the option for sorting on one column. You can file a request for that feature in the new Spotfire Ideas Portal that was developed by our Product Management team:




Beyond that, if the need was strong enough, you could technically create a column with some index that was the desired multi-column sort order, and then sort on that single column in the cross table. That would be very dependent on your data, cross table configuration, and would require you display that index column in your cross table so it might not be a great solution. But if it were, you can post those details and I can help with that.

Link to comment
Share on other sites

  • 2 years later...

The only way that I've found to do this is to:


Go to View > Data to show the data pane.

Select the data point on which your column (or row) is based and click the gear icon to expand the data panel for the data point.

Select theSort orderdrop down list and selectCustom.

Click the Settingsicon (again...gear icon) and manually order the values for your data point.


Hope this helps!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...