3 Replies Latest reply on Jan 25, 2019 9:30 PM by Zhouyi Zhang

    how to sort and rank a table with specific column orders?

    Jesse yung

      Hi, I have a table with columns owner, product and date. Now I'm asked to add a column rank to rank the date each product is created within each owner segment and I couldn't shift the date column to the left, then I need to sort the rank column ascending. Anyone knows how to pull this off?

       

      As in the attached workbook, currently I can rank it but not sort it.

      Screen Shot 2019-01-25 at 5.56.06 PM.png

      Thanks tons.