Ranking functions in charts
These functions can only be used in chart expressions.Note: Suppression of zero values is automatically disabled when these functions are used. NULL values are disregarded.
Rank() evaluates the rows of the chart in the expression, and for each row, displays the relative position of the value of the dimension evaluated in the expression. When evaluating the expression, the function compares the result with the result of the other rows containing the current column segment and returns the ranking of the current row within the segment.
rank([TOTAL [<fld {, fld}>]] expr[, mode[, fmt]])
HRank() evaluates the expression, and compares the result with the result of the other columns containing the current row segment of a pivot table. The function then returns the ranking of the current column within the segment.
HRank([TOTAL] expr[, mode[, fmt]])