Listing only the Top 10 entries in a data set


SolveXia Analytics & Reporting provides a simple way to create powerful reports based on managed tables. With the latest BI and data visualisation techniques, you can create reports that communicate and inform effectively.

This article will explain how to create a table which includes only the largest ten values from within a data field, along with any other fields corresponding to those values.

Before we get started

Before you start, please ensure that you have a managed table with at least one row of data. If you need help to create a managed table or to import data into a managed table, please refer to the articles below.

[message type=”warning”]For the purposes of this article we will continue to use the example from the How to create a tabular report with Drill-Through capability tutorial.[/message]


1. [highlight txt=’Create’] a new Report with the managed table used in the How to create a tabular report with Drill-Through capability tutorial.

2. At the ‘Report Data’ stage, [highlight txt=’drag’], from the [highlight txt=’Data Field’] pane into the [highlight txt=’Columns’] pane, the ‘AirlineInfo_Date’ field once and the ‘AirlineInfo_Amount’ field twice.

3. [highlight txt=’Aggregate’] both of the ‘AirlineInfo_Amount’ fields.

4. Select the second ‘AirlineInfo_Amount’ field.

5. Click the ‘Advanced Function’ option.

6. A new browser window will pop up (please make sure that the ‘pop-up blocker’ of your browser is not blocking pop-ups from the website). The dropdown for function should be set to ‘Analysis’ by default.

7. Scroll down to the ‘Top 10 Rank’ function by clicking on the arrow pointing downwards.

8. Select the the ‘Top 10 Rank’ function.

9. Click the [highlight txt=’Save’].

10. [highlight txt=’Navigate’] to the ‘Preview’ stage.

11. Click the arrow at the right side of the header cell of the ‘Rank of AirlineInfo_Amount ‘ column.

12. A dropdown will appear. Select ‘Sort Ascending’ from the dropdown.

13. The table will now be sorted by Rank:

Recent Posts

Leave a Comment

Contact Us

To learn more about SolveXia, please use the form below to send us an email. One of our team members will contact you.

Not readable? Change text. captcha txt

Start typing and press Enter to search