12 Replies Latest reply: Nov 8, 2018 9:28 AM by Sunny Talwar RSS

    Set Analysis based on Rank

    yossi birenboim


      I'm struggling with this issue for several days.

      I want to calculate the Total value of the N customers with the same conditions.

      Meaning, first calculate the total sale per Customer with some conditions (set analysis), then rank them, and finally sum the total sales for the first N top customer. the N is a variable the can be changed by the user.


      somthing like this

      sum(<{Field1={''},field2={''}, Customer = { Rank( sum(< {Field1={''},field2={''} > Sales } <= $(NTopCustomer))} Sales)