1 Reply Latest reply on Sep 12, 2016 11:42 AM by Michel Caissie Branched from an earlier discussion.

    Sort Cross Tab table using parameter

    lukasz.c

      Hi,

       

      I found a problem with sorting -on cross tab.

      I've tried to create sort variable but when I add it my cross tab produces more columns

       

      The goal is to sort values horizontally and vertically - ascending and descending

      I've attached sample report.

      Thanks in advance

        • 1. Re: Sort Cross Tab table using parameter
          Michel Caissie

          Lukasz,

           

           

          When you add an index in a view, depending on the dimensions on the rows and columns, and depending on the table computation, it may do some domain completion and add some marks.

          As you can see in your case you go from 11 to 29 marks.  So it will be difficult for you to use the index function for the sorting.

          If the current and Next Marker have only a few values like in your example, then you can go with the alternate solution proposed in the attachment.

           

          Michel

          1 of 1 people found this helpful