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.
Result of CustomersAmountRanking query
What must be done here is:
- Drag the Invoice Amount query element to the “Order by” area.
- 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.
- 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.