4 Replies Latest reply: Nov 14, 2011 7:07 AM by Marc Livingston RSS

    List box sorting by customer order value, need to limit to only show top 50

      I have an issue I am trying to work out. I am trying to have a list box that allows selection of top 50 customers.

       

      Currently I have the list box displaying customers, sorted by this expression: =aggr(sum([Order Amount]),Customer)

       

      This is correctly listing the customers to show the Top customer at the top, lowest at the bottom. Now I need to reduce this list to only show 50 values. Is this possible?

       

       

      I could also work with a button that selects the top 50, I just do not know where to start.