BOTTOMN
Bottom N function displays the lowest n values of the expression argument from 1 to n, 1 corresponding to the lowest numeric value.
The BOTTOMN function operates on the values returned in the result set. A request can contain only one BOTTOMN expression.
Syntax
BOTTOMN(numExpr, integer)
numExpr is any expression that evaluates to a numeric value.
integer is any positive integer.
Represents the bottom number of rankings displayed in the result set, 1 being the lowest rank.
Example,
BOTTOMN (“measure Column”,5)
It shows the Bottom low values up to 5 rows, and it ranks as lowest value as 1 and 2…
Here I am going to calculate for one revenue according to the monthly base for the year of Bottom N ranks.
Take a look of report before using bottom ranks.
Here I used Total revenue actual values according to the month. Calculate the revenue of bottom ranks based on the months.
Negative values are the lowest values.
According to the bottom 5 , the 1st lowest value will be May= -3779467.1
2nd lowest value will be June = - 3093948.9 and so on.
Calculation formula used here is
BottomN (“Measure column “, 5)
BOTTOMN FUNCTION IN OBIEE 11G |
BOTTOMN (“W_DAILY_REV_DFT_F”.”Actual Sum”,5)
W_DAILY_REV_DFT_F Actual Sum denotes the measure column.
Bottom 5 values have to show denoted by 5 next to the measure column.
Take a look on the result of 5 Bottom Revenue.
BOTTOMN FUNCTION IN OBIEE 11G |
Comments
Post a Comment