5 Replies Latest reply on Sep 3, 2017 1:47 PM by Shinichiro Murakami

    Total for Top N only

    Michael Franz

      I have a list of customers. About 20,000.

       

      I have a top N Parameter to type on the number of Top-N's to add

       

      I want to sum the revenue of just the top-N someone picked.

       

      For example, someone puts 10 in the parameter box, the result I am looking for is $xxx,xxx revenue. Just a number, not a list.

       

      The only fields I have are customer #, customer name, and Commission revenue.