Sort header-row after cross tabbing

Question

Hello - I'm struglling to get these headers sorted geographically, Northeast = 1, Mid Atlantic = 2, Southeast = 3, Great Lakes = 4, Central = 5, Northwest = 6, West = 7 and total = 8.

I wrote a formula similar to the above and tried to sort before cross-tabbing but it automatically sorted alphabetically. Any help would be appreciated!

binu_acs · Answer

@dottman one way of doing this

Cross_Tab_30042024.yxmd

alexnajm · Answer

Before you Crosstab, I would add the 1, 2, 3, etc. to the beginning of the region - i.e. 1_Northeast, 2_MidAtlantic, etc.

That way, they should show in the correct order after the Crosstab. Then you can remove the numbers with a Dynamic Rename tool after the Crosstab! Likely a RegEx replace - I can try to help further if you send your workflow and a sample of the data