Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dimension, 'n', with values ranging from 0 - 10. I want to show the rank of 'n' in text boxes based on the selections I make.
So if the possible values of 'n' are 3, 5, and 7 then I want to show:
Rank of 3: 1
Rank of 5: 2
Rank of 7: 3
An expression like the following should do the trick:
match(7, $(=concat(distinct n, ', ', n)))
You would just replace the 7 with whatever number you're looking to rank.
I've also attached a sample file.