Top N

The Top N feature allows you to display only a limited number of values that correspond to the highest or lowest values of a particular measure. To display the top values in a dimension, select Top N from the data item menu.

Enabled: Turns on the Top N feature. No other options are active when Top N is not enabled.

Mode: Selects whether the Top (largest) or Bottom (smallest) values will be included in the output.

Count: Determines how many results will show.

Measure: Specifies what value will be used to calculate the top or bottom results. Hidden measures are included here along with all visible measures.

Show “Others” value: Indicates if a catch-all category will be included for values outside the specified count.