2 Replies Latest reply on Aug 11, 2018 8:13 AM by Matthew Hefferon

    Retain Sort Order without column showing in Crosstab

    Matthew Hefferon

      Hey Community,


      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.


      Screen Shot 2018-08-10 at 1.23.59 PM.png


      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:

      Screen Shot 2018-08-10 at 1.24.13 PM.png


      Any ideas on how I can remove Category but keep the sort order as if it was still there?

      Screen Shot 2018-08-10 at 1.24.29 PM.png