Can someone help with the below grid to be sorted by month order, not alphabetical.
April | 59362695.77 |
August | 88065329.94 |
December | 86659085.87 |
February | 27117735.67 |
January | 59912193.9 |
July | 79757626.22 |
June | 70884268.54 |
March | 45235901.16 |
May | 89641660.98 |
November | 95846400.13 |
October | 83070284.84 |
September | 75695732.11 |
I saw some past posts about it, but still cannot get it to work.
Solved! Go to Solution.
Hi @Lauriek,
Please refer my solution below, I first convert the month names into date data type, and sort them in numeric format.
Hope this helps!
@Lauriek
If only for Months, we may create a lookup take in this way, the calculation load will be less if the data is huge.
That worked! Thank you for the help.