Forum Discussion
Help! Month Ordering Problem
First and foremost, thank you SO MUCH to whoever can help me! I have a presentation on this within the next few hours and I can't seem to get the months for a matrix to line up properly. I looked up how to do it, but it didn't work.
Attached are the pictures. I made a month order column and sorted the months to that column. I also added a date column because I have another Page with the same report and the data has a data column, so I'm not sure if that made a difference.
Can anyone tell me why it's STILL not working?
Hi - Can you ensure that, under the Table View of the table with the dates, you've chosen to sort the "Month" column by the "Month Order" column?
If not, to do this from the Table view:
- highlight/select the Month column
- choose the "sort by column" from the "column tools" menu
- choose to sort by Month Order
Screenshot below where I've got slightly different column names to you, but same principle applies
Good luck!
Matt
3 Replies
Thank you both for your advice! It's now fixed and ready to knock my President's socks off, haha.
For your reference.
Step 1: I select ’Month' column in 'Table view'.
Step 2: I click 'Sort by column' and click 'Month Order'.
Hi - Can you ensure that, under the Table View of the table with the dates, you've chosen to sort the "Month" column by the "Month Order" column?
If not, to do this from the Table view:
- highlight/select the Month column
- choose the "sort by column" from the "column tools" menu
- choose to sort by Month Order
Screenshot below where I've got slightly different column names to you, but same principle applies
Good luck!
Matt
