Forum Discussion
Sort by column not working
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 e...
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!
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.
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!