1. Home
  2. Knowledge Base
  3. Ad Hoc Views
  4. Ad Hoc View – Crosstab Top 10 Filter

Ad Hoc View – Crosstab Top 10 Filter

Crosstabs also allow you to filter numeric data based on the top or bottom results.

Crosstabs have different data, layout and format options than tables or charts. Crosstabs are similar to Pivot Tables that you may have used in other systems.

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

Ad Hoc Views can be viewed in the Community BI system or in reports and dashboard.


Step 1. Create or open a Crosstab Ad Hoc View (refer to the Ad Hoc View – Crosstab article for further information).

Step 2. Right Click on the measure you wish to filter on.

Right Click on measure


Step 3. Select Filter Top N Values…

Select Filter Value

Step 4. Enter the number of top values to show i.e. Top 10, Top 5.

Tip: If the Show aggregate of unranked values check box is selected, all remaining results will be displayed in a group labelled 'Other'.

The filtered results are displayed.

Top 10 results

Save the changes if required.

Refer to Saving Ad Hoc Views article for further information.

Step 5.  To remove the filter, right click on the measures header

Right click filtered measure

Tip: The blue dot next to the Filter Top N Values...  shows that it is currently active

Step 6.  Select Don’t filter Values to remove the filter

Filter removed

The filter is removed and all data is displayed.

Further Information

For further information, refer to the following articles:

Updated on April 19, 2018

Related Articles