Bottom N function displays the lowest n values of the
expression argument from 1 to n, 1 corresponding to the lowest numeric value.
Syntax: BottomN(expr, integer)
Syntax description
expr is any
expression that evaluates to a numerical value.
integer is
any positive integer. Represents the bottom number of rankings displayed in the
result set, 1 being the lowest rank.
Steps: Go to Criterial – Select the Column – Right Click –
Select Edit Formula – Click on Insert function – click on Aggregate folder and
select BottomN
Example: BottomN("Sales"."Rp Revenue", 2)
No comments:
Post a Comment