Rank Descending (as a column)

  • Type: Inserted as a column
  • Description: Ranks values according to their numeric size. Highest value equals rank 1.
  • Range:
    • Columns: Last column
    • Rows: All rows
    • Measures: First measure
  • Syntax:
rankdesc(d-1, all, m1)
  • Sample crosstab:

 

Example

In the table above we want to calculate the descending rank of the rows the last column (in a column).

Adding the calculation, the table now looks like this:

 

 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.