3 Replies Latest reply on Dec 6, 2016 8:02 PM by Kenneth Li

    Sort the countries according to number of distinct value in a field

    Kenneth Li

      Hi,

      I have created a table like below. What I wanted to do is for each country, how many columns >0 are available and sort in descending order.

      e.g. Argentina 2 columns >0

      Australia, 1 columns >0

      Austria, 5 columns >0

      i.e. Austria -> Argentina -> Australia ....

      Capture.PNG

      I am wondering if there is a way to count based on the table and then I can directly sort that field afterwards.

      Thanks.

       

      Kenneth