按轴上的完整数字排序 [英] Sort by full number in axis

问题描述

是否可以通过以全数结尾对列进行排序?

Is it possible somehow to sort the columns by ending full number?

如您所见，第 10 个月是第 2 个月.还是有其他方法可以解决此问题?

As you can see Month 10 i number 2. Or is there other approaches to solve this?

推荐答案

由于列的数据类型是文本，与 2,3 等相比，1,10,100 结尾将被视为第一.因此，您需要按其他列对该​​列进行排序，如下所示:

As the data type of the column is text, 1,10,100 ending would be considered 1st as compared to 2,3 etc. So you need to sort that column by some other column as seen below:

您可以创建映射表映射 Month1>1 ；MONth2>2 等并利用它.

You can create a mapping table mapping Month1>1 ; MOnth2>2 etc and Leverage it.

希望这就是你所要求的:)

Hope this is what you are asking for :)

这篇关于按轴上的完整数字排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！