3 Replies Latest reply: Apr 9, 2015 11:49 AM by Philip Hand RSS

    Sum of Top n values in a text field

    David Brandstädter

      Hi all,

       

      I'm trying to calculate the sum of the 5 largest values of one dimension. I tried set analysis and Aggr fuction combined with the Rank() function but did not succeed yet.

       

      Attached a simple example of my problem:

      • 20 entries (line items) of "sales records".
      • 10 different customers
      • The TOP5 customers have a total of 51,446 sales.

       

      This sum (51,446) is what I would like to calculate in a formula to replace the static blue coloured text.

       

       

      Thank you!

      topsums.PNG