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.
