4 Replies Latest reply: Dec 2, 2014 5:59 PM by Melissa Li Shi RSS

    Add a rank column to straight table

      Hi I want to add a column to rank the accounts by Total Units. I sorted by Total Units and added the Rank expression but is not displaying as I am expecting it to. I would like to see Account E listed as 1, Account C listed as 2, Account D listed as 3 and so on.


      I use this as the expression =rank([Total Units]) but only returning 1s


      Total Units is Sum({CalendaryYear = {$=max(CalendarYear)}>} QuantityShipped)


      Please help, thank you in advance!