4 Replies Latest reply on Jul 28, 2013 6:35 AM by giles.somers

    Sort a dimension descending by a calculated measure value

    Katy Holmes

      I am trying to sort a dimension by a calculated measure (percent of total). I know that I can do this using quick sort and this works very well, but when the user changes the filter to display a different set of data, I want the sort to update automatically to reflect the change in the data. I can't seem to set this up using the sort dialogue on the dimension field, but it can't be that difficult!

      Any suggestions appreciated - I've attached some sample data to show my query. It all looks fine in the display, but change the year filter and it goes wrong.

      Thanks,

       

      Katy