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