For example if the test scores are as follows
1 Tom 53
2 John 43
3 Ellie 32
and I select John, I would like to see
2 John 43
Currently when I select just John, since he would be the only entry, I see
1 John 43
Hi @Jack Crabb - Tableau performs the filter prior to the rank calculation, hence why it's recalculating each time.
You need to force the rank to calculate before the filter.
In order to do this, you can trick it by creating a table calculation around your name:
Create a calculated field like this:
LOOKUP(MAX([Person]),0)
Drag this onto your filter pane. I like to adjust the table calc and compute using specific dimensions, just to ensure this doesn't go awry later.
The reason this works is it's changing the order of operations. The lookup function doesn't change the value of the person record: For each person record take the max person at position 0 (current position)., therefor outputting the same value.
I personally tend to use the lookup function but other table calcs work as well. This video does a great job explaining it:
