This content has been marked as final. Show 2 replies
I'm hoping you guys have a clever solution to this issue I'm facing. I've attached a sample workbook.
Example Issue I'm facing:
I have category and sub-category and this is sorted alphabetically by Category (which is what I want). When I download the data as a Crosstab I don't want to see Category in the result set but I do want to keep this sort order.
I can hide Category and it retains the proper sort order in my workbook but when you download as a Crosstab it still contains Category in the result set:
Any ideas on how I can remove Category but keep the sort order as if it was still there?