I am attempting to find a way to specify the order of data within a column when the order is not simply ascending/descending. For example my dataset will have
But in my output I need the order to be
i.e. not alphabetical or reversed-alphabetical order, but a specific one. I can preserve the order of the data after running a List Report, but I have been unable to run a filter (or whatever the process is) to get the data into the correct order before a Report step.
If anyone has any thoughts or suggestions, I’d appreciate them.
All of Doc's suggestions are right on the money. The lazy person's solution would be to recode the column so the values are:
1 - X
2 - Z
3 - Y
4 - W
If this is acceptable, it's definitely a simple solution (and one I've used many, many times). If you MUST have the values stay X, Y, W, Z; I would recommend Doc's approach of recording the values similar to above (1 - X, 2 - Z,...) and creating a custom format that causes 1 - X to display as X. If you then order by the Unformatted values, you're good to go. As Doc mentions, this trick will not necessarily works in every possible situation, though it works in most of them.