I'm creating a workflow that pulls our top customers for the current month and compares them through the past couple months. I'm using a crosstab to group by the customers and make the months the column headers. My issue here is that when I try to sort after the crosstab, the sort is not recognizing the new months columns. It only recognizes the customer name column. I previously used this workflow with an in-db tool and the sort worked then but it isn't working for me when I use a Teradata bulk loader. How do I fix this?
