Syntax
RANK_ANLS(X_AGG(Array),Range,Order)
Indicators are ranked across rows based on fields added to horizontal/vertical axes or row/column dimensions.
Parameter 1
SUM_AGG(Array)
The first parameter is the indicator to be ranked, which must be an aggregation function or aggregation indicator.
An aggregation indicator refers to the result obtained by using an aggregation function.
Parameter 2
Range
The second parameter Range is used to set the calculation range. You can set Range to 0 (ranking all rows) or 1 (ranking all rows within each group).
Parameter 3
Order
The third parameter Order specifies the ranking rule. You can set Order to asc (ascending) or desc (descending).
The value of the third parameter is case-insensitive, which can also be DESC or ASC.
RANK_ANLS(SUM_AGG(Total Amount),0,"asc"): When you drag the Contract Type field into the horizontal axis, the function groups and aggregates the total amount by contract type, and ranks the total amount in the ascending order across all contract types.
You can download the sample data Contract Fact Table.xlsx.
Rank the total amount, for example, rank the total amount of each contract type in the ascending order.
Add a calculation field named Ranking by the formula RANK_ANLS(SUM_AGG(Total Amount),0,"asc"), as shown in the following figure.
For details about how to write functions, see Function Calculation Format.
Drag Contract Type, Total Amount, and Ranking into the analysis area, and select Ascend from the drop-down list of the Total Amount field, as shown in the following figure.
The total amount is ranked by contract type in the ascending order, as shown in the following figure.
Quick Calculation - Ranking
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy