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
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