1 of 1 people found this helpful
In order to get a rank you would sort your totals by YTD desc. Create a calculated field with only index() in its formula.
Place this field at the beginning of the rows shelf.
Rank will still show a value for totals although it doesn't make sense to have a value.
This only works for the vertical values so YTD will need to exist in your data or through a calculated field that adds up all of the month values.
Hope this helps.
The complication I have is that the data is coming out of a cube, and I've found it nigh on impossible to get a rank in the display with row totals showing and using index() at the same time (which I then wanted to filter down so only the top 20 or 40 displayed).
The ideal presentation is to (1) have the league table rank as the first column displayed, (2) not have it populated in the totals line and (3) allow me to show the top 20 as is, to put a fold on "all others" for the remainder summed together, and then the total at the end. But that feels like a major hack...
In the meantime, just the league rank anyway would help :-)