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!

      2014-12-02_9-48-19.png