8 Replies Latest reply on Oct 4, 2016 6:48 AM by Henrietta Bathurst

    Including minus numbers in a Top N calculation

    Henrietta Bathurst

      Hi all,

       

      I'm trying to show movement across years (using trans dates) and have managed by using a Top N calculation to show the largest positive movements, however I would also like my table to show the largest negative movements (e.g. losses).

       

      If anyone has any suggestions as to how to achieve this/whether or not it is possible it would be greatly appreciated!

       

      Thanks in advance