I'm using the Subfield function to break up the flow of a customer. For example, the flow of a customer 123 is 1>2>3>7>3 and the flow of customer 456 is 2>4>5>1>3
I'm using the subfield like this subfield(Flow, '>'). I want to keep them in the order of the flow and not in numerical order. I would like to have two columns. One for flow state and the other for customer ID. So it would be like below. However, I've done all of the above and created a table box, but the order of the flow isn't accurate, even when I update the flow property in the sort table to 'Load Order-Orginial'. Thoughts anyone?