How to get max ranking value?
I have a situation where I can calculate the ranked top 10 values of a key figure using a condition. One of the columns I have uses the ranking calculation.
So I now have the top 10 values. I now need the maximum ranking value so I can know what the ranking is out of. So I would like to show the following:
Rank Out of
So even though I am only showing 10 values in need to know the maximum number of records for the 'Out of' column.