10 Replies Latest reply on Oct 6, 2016 10:39 AM by Andrew Watson

    University names in a filter drop-down - how to sort?

    Caroline Beavon

      I'm using a list of all the universities in the UK to create a drop-down quick filter for my users.

       

      i need these sorting not alphabetically by the first letter but in a more logical matter

       

      Eg.

       

      The University of Surrey

      The University of Sussex

      Swansea University

      Teeside University

       

      My solution was to change the SORT option in the Default Settings for that dimension.

       

      The names are in the right order in the data, but if I select "data order" but it forces it into an alphabetical sort instead.

       

      My initial solution was to manually reorder them, however, when new universities are added, or there are name changes, those new ones need resorting (not ideal for my client to have to deal with)

       

      Any suggestions welcome.

       

      Thanks