Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Custom sort of Matrix rows

Hi everyone, I am trying to sort some areas in a Matrix table so it looks like the below

 

 

I was thinking by creating a table sorted by index and creating a relationship between LTLA in this table ( and LTLA in my fact table, the matrix would sort in the above order. How it sorts like below (i.e. alphabetical) - can anyone advise please? Thank you.

 

 

Need Help
Show and Tell
Tutorial Requests

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks, I have done the sort by column but it still doesn't seem to work. If I drop 'index' in to the rows field of the visualisation I do get 1-6.

       

       

      However when I put LTLA in it reverts to sorting alphabetically

       

      Table is set up like below, are you able to advise further please?

       

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I have exacly the same problem 😞