Dynamic Button to Select Top n Values

[#1]

Hi,

I want to have a button that when pressed selects the top n values of a field but I also would really like a user to be able to input how many values and which of the fields (Cost, Revenue, Margin) it selects over.

In the button options I have tried 'Select in Field' but don't know what to put for the Search String. I also don't know how to incorporate inputs into a buttons functionality.

Any help would be much appreciated!

[rustyfishbones]

You can use

='(' & CONCAT(IF(AGGR(RANK(Sum(Sales)),Customer) <= 5,Customer),'|') & ')'

and you could create a variable in place of the <=5 so the user can dynamically select the Top N values

This will Select the Top 5 Customer based on Sales

Regards

Alan