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