Sort by column not working

[Anonymous]

I have a Matrix and I want the Row item to be sorted in a specific order.

I created a column in Query Editor called 'Order' and i've used an IF statement to define the order as 01, 02, 03 etc. I ensured the column is a Whole Number. 

I've then sorted my Row item by the Order column in the Modelling tab, and it's made no difference to the order whatsoever!

Below are some screenshots, have I missed something obvious?

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'

[Anonymous]

I created a column in Query Editor called 'Order' and i've used an IF statement to define the order as 01, 02, 03 etc. I ensured the column is a Whole Number. 

I've then sorted my Row item by the Order column in the Modelling tab, and it's made no difference to the order whatsoever!

Below are some screenshots, have I missed something obvious?

[Greg_Deckler]

I'm missing something, all of your Order's are 1?

[Anonymous]

@Greg_Deckler

That's just a bad preview - if the P&L item is Gross Written Premium (which all of the first rows are) then the order number is 1. 

I have checked the full dataset and there are numbers 1-19 in there I promise. 

[Anonymous · Accepted solution]

@Greg_Deckler

Wow do I feel stoopid. It had not occured to me to check WHAT order it was using. When I did, I realised it WAS using the right order. I must have had my Matrix sorted by something else, when I clicked on my Row Item to sort by that, it works!

Sorry for all the fuss!

[Greg_Deckler]

OK, so what order are you seeing?

1

11

12

13

14

15

16

17

18

19

2

3

...

Or something else?