Creating queries to obtain rankings

In creating rankings, the Maximum number of rows is ideal to clear the top rankings and delimit information.

For instance, in the Invoicing query, where we show the customer’s name, the invoice date and the selling price, we want to analyze only the first fifteen customers with the highest figures in sales, as shown below.

GXquery4 - Customers Amount Ranking

Result of CustomersAmountRanking query

What must be done here is:

  1. Drag the Invoice Amount query element to the “Order by” area.
  2. Select it and, in the Order property, assign to it the Descending value so that the higher amounts of sales appear at the top of the list.
  3. And, enter value 15 in the query’s Maximum number of rows property (to view the properties click on the Invoicing tab).

Press View to see the result.