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

    Sum of Top n values in a text field

      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!