Forum Discussion
sort months into chronological order
Hi, Anonymous
You can create a sorted table, then establish a one-to-many relationship between the sorted table and the main table, use the RELATED function to create a sorting column in the main table, and finally make the rolling column sort by the sort column.
sample:
result:
Please refer to the attachment below for details
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi, Anonymous
I noticed that the value in your sort table is "Rest of the Year", but the mapped value in your main table is "Rest of the Dates", and the value is different causing this to not correctly identify the sort order.
Best Regards,
Community Support Team _ Zeon Zheng
Hiya thanks for the reply.
How do I make them *:1 in the same table?
Community SupportHi, Anonymous
You can create a sorted table, then establish a one-to-many relationship between the sorted table and the main table, use the RELATED function to create a sorting column in the main table, and finally make the rolling column sort by the sort column.
sample:
result:
Please refer to the attachment below for details
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You are a genius!
Thank you so much!Small issue im now having.
I have 6 months values being shown and rest of the year/s totaled at the end, however, 'rest of the year' is showing up before the final month in my 6 months which is January.
heres some pics for reference:- v-angzheng-msft
Hi, Anonymous
I noticed that the value in your sort table is "Rest of the Year", but the mapped value in your main table is "Rest of the Dates", and the value is different causing this to not correctly identify the sort order.
Best Regards,
Community Support Team _ Zeon ZhengThat sorted the issue, thank you!!