Forum Discussion

gray_davidson's avatar
gray_davidson
Cloud Apps
11-07-2023

Sorting Bug in Pivot Table

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.   

1 Reply

Replies have been turned off for this discussion
  • HamzaJ's avatar
    HamzaJ
    Data Integration

    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