BottomN Function

BottomN function displays the lowest values from 1 to n, where 1 is the lowest numeric value.

Syntax:

BottomN(expr, integer)

Expr:                      It is an expression of a measure

Integer:                                It can be any positive number

Example:

      1)      Select the necessary columns

    2)   Add another measure or the same measure

Click on the measure -> edit formula

Select BottomN function

F() -Functions - Aggregate - BottomN

Integer can be anything from 1 – N depending on the number of rows in the Column. 

Result: 

The result shows the top lowest bottom revenue