2 Replies Latest reply: Aug 3, 2018 12:04 PM by Itamar Chubb RSS

    Sorting a column

    Itamar Chubb

      Hi,

       

      How do I sort the column with the blue arrow (preference to descending):

      sorting.PNG

        • Re: Sorting a column
          Sibin Jacob.C C

          Go to Sorting tab.

          Then Select Country -> the select sort by expression option.

           

          For example your expression is Sum(Sales), then write the below expression in sorting tab.

          I am assuming you need to sort table order based on Review Type Null

           

          Sum({<Review_Type-={"*"}>} Sales)


          Then select Decending Order.


          If you need to sort based on Review Type 'No Owner', the sort tab expression will be

          Sum({<Review_Type={'No Owner'}>} Sales)


          Dynamic sorting is not available in Pivot table, which is available only in Straight table.