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

    Sorting a column

    Itamar Chubb



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


        • 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.