In query options, enter a number in the Top N option. Our example is 20.

Distinct Rows Only. Use if dimension(s) used for query result in multiple rows when a single row is needed.

Dimension Only. Use if the information to be displayed does not include any facts. For example: a list of cost centers and their related descriptions.