1. Home
  2. Knowledge Base
  3. Ad Hoc Views
  4. Ad Hoc View – Change Sorting Order

Ad Hoc View – Change Sorting Order

When displaying information in Table or Crosstab Ad Hoc View, you may wish to change the sorting order of the returned information.

Ad Hoc Views allow you to visualise and analyse the data you capture for your organisation.


Step 1. Once your view has been created (link to BI Ad Hoc View article) you may wish to change the sorting order.

Tip: By default the rows and columns of crosstabs are sorted in alphabetical order of the group names.

Step 2. Create/open your view.

Step 3. Right Click on the measure name in the view area.

The Sorting options appear in the menu

Sort Options

Step 4. Select Sort Ascending

Sort Ascending


The Selected field will be sorted in ascending order.

You can change the sorting option to Sort Ascending, Sort Descending, or Don’t Sort.


Step 5.  If required, select a second field to sort.

Tip: If multiple row groups or multiple column groups are present, the inner groups are also sorted according to your selection. 
Tip: Only one measure can be used for sorting at any one time.  


When completed, save your view as required

Further information

For further information refer to these articles:

Updated on April 19, 2018

Related Articles