Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sort by is not working

I have a matrix and I want the Row item (called Product) to be sorted in a specific order so I created a column in Query Editor called 'Order' and i've used an IF statement to define the order as 01,...
Need Help
themistoklis's avatar
themistoklis
Community Champion
7 years ago

Anonymous

 

Make sure that the format of the field is of data type: Whole Number and not Text or anything else.

 

When you say you cant see the ordering... do you mean that you created a table object or chart and the ordering is not working?

Or you just want to see the ordering on the background data?

 

Also have you used the sort by column on Modelling tab?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

themistoklis

 

Yep i've used whole number, and I created a matrix and the ordering is not working. 

Yes I used the sort by column on the modelling tab. 

 

When I applied the sort by, it did not affect the order in the matrix. It's like it's not recognising the Order column, but it's not erroring. 

  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

    Anonymous

     

    Can you share the workbook with us so as to have a look at it?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      themistoklis

       

      I've attached some screenshots of the relevant areas, I can't attach the worksheet due to the data it contains. 

       

      In Query Editor, the Order column is 'whole number'The M Query formula used to create the 'Order' columnThe Row item is sorted by 'Order'In the table, the Order column still shows as Whole Number and contains values 1 to 26