Custom sort the summarized output (pivot table)

[BJSOON]

Hi,

I would like to find out a way to custom sort my summarized output.  

Default sorting in output

Cancel	Sum_Count
(Blank)	6022
1	22
10	26
11a	18
11b	201
12a	10
12b	190
12c	43
2	60
3	2
4	162
5	137
7	124
8	533

Desired sorting

Cancel	Sum_Count
1	22
2	60
3	2
4	162
5	137
7	124
8	533
10	26
11a	18
11b	201
12a	10
12b	190
12c	43
(Blank)	6022

Thank you in advance!

[BJSOON]

Yes, the logic works but the size of the field is the issue.  I did try with AutoField but it still didn't work.

I tried @MichalM tool but I don't know how to "use RegEx Parse to split the column into Numbers and Letters"...

[MichalM · Accepted solution]

The workflow is attached to my previous post. Here's the RegEx Expression

(\d+)([a-zA-Z]+)

[BJSOON]

Thanks! Sorry I missed the workflow which you attached in your earlier message.  I will give this a try!

[BJSOON]

Thank you!