Sorting Bug in Pivot Table

[gray_davidson]

I'm getting an odd bug in Fusion Pivot tables where columns will not sort (except first column which /can/ sort). 

The first column (a list of the names of various schools) will sort just fine ASC and DESC.  For any other column sorting has no effect. 

Anyone else have this bug?  Is there a setting I've changed which is causing this?  Other pivot tables in my instance work just fine.   

[HamzaJ]

Hey @gray_davidson 

The pivot groups rows together and sorts columns within the groups its in. This means that the first column is sortable as you would expect, however the second (and Nth ) columns will sort within the group (in this case the first column) and not over the entire table. Lets say a program has 2 providers (in your case) when sorting on providers it will sort the provider for that program and not over the entire table. 

If you would like something like that you would need to switch to for example a Table with aggregation -type

Hamza