5 Replies Latest reply on Aug 22, 2013 12:45 AM by Leticia Soroa

    How can I sort a table and get TOP N by a field calculated in this way "LOOKUP(SUM([JTZ]), -1 ) - SUM([JTZ])" ?

    Leticia Soroa

      Hi,

       

      I am calculating the difference in exposure from two dates so I am using the formula LOOKUP(SUM([JTZ]), -1 ) - SUM([JTZ]).

       

      This works perfectly fine however I would like to order my table by ASC or DESC. Currently I can do it in ascending order if I put my calculated value as first field in the rows section and hide the column (not ideal) .

       

      How can I get top N? Index() does not seem to work in this case.

       

      Thanks,

      Leticia