7 Replies Latest reply on May 20, 2019 2:56 AM by giovanni.orfino

    sorting with multiple column

    giovanni.orfino

      Hi,

       

      I have created this table showing the number of records (divided by 3 different criteria) and the % against each on.

      Now I was asked to sort them by the % (the % is a calculated field of the sum number of records "Percent of Total Table (across)

       

      example 1.png

       

       

      Ideally I want users of the dashboard to be able for use to select each criteria (matched, not found and partially matched) and sort them.

      With rank I get this which is not good.

       

       

      example 2.png

       

       

      any idea pls?

      Appreciate your help

       

      Gio