Hi,
I need to sort one dimension in a table that contains both numeric values and text values.
I have the following numbers and text value:
| HBM24203 |
| HBM24438 |
| 1131 |
| 1112 |
| HBM24518 |
| HBM24507 |
| HBM24451 |
| 1170 |
| 1162 |
| 1161 |
| 1153 |
| 1151 |
| 1122 |
| 1117 |
| 1115 |
| HBM24120 |
| HBM24119 |
| HBM24109 |
| HBM24098 |
| HBM24050 |
| HBM24248 |
| HBM24219 |
| HBM24214 |
| 1142 |
| 1141 |
| 1135 |
| 1132 |
| 1114 |
| 1125 |
| 1123 |
| HBM24142 |
| 1143 |
| HBM24047 |
| 1148 |
| 1144 |
| HBM24297 |
| HBM23994 |
| HBM24331 |
I would like to sort like this:(first sort by numbers and then by text):
| 1112 |
| 1114 |
| 1115 |
| 1117 |
| 1122 |
| 1123 |
| 1125 |
| 1131 |
| 1132 |
| 1135 |
| 1141 |
| 1142 |
| 1143 |
| 1144 |
| 1148 |
| 1151 |
| 1153 |
| 1161 |
| 1162 |
| 1170 |
| HBM23994 |
| HBM24047 |
| HBM24050 |
| HBM24098 |
| HBM24109 |
| HBM24119 |
| HBM24120 |
| HBM24142 |
| HBM24203 |
| HBM24214 |
| HBM24219 |
| HBM24248 |
| HBM24297 |
| HBM24331 |
| HBM24438 |
| HBM24451 |
| HBM24507 |
| HBM24518 |
