Regarding Sorting of data having different format in same column

[Sap]

In my data there is a period column. I need my data in sorting. like 1-Month,3-Month,6_Month,1_Year in this manner. what is the solution for it.

period
1_years
2_years
3_years
5_years
1_months
3_months
6_months
2021
2022
2019
2020
2018
2023

[Wilson_]

Hello Sap,

Maybe this article about custom sort order will be of use to you. 😄

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)