Hello,
So there seems to be a lot of info on ranking but none of it quite solves the problem i am having.
Essentially all i want to do is rank a whole load of names by the number of sales they have made - which is the easy part. But when i filter it to look at one name, it always shows that person as #1 - but i would like it to keep the number they were at when it was not filtered. Any ideas?
Thanks in advance!
Nathan
Hi Nathan,
Dimension filters in Tableau are applied before the table calculations. So filtering on the raw dimension would mean, Tableau filters that dimension first then executes the table calculation operation (opposite of what you want) which is why it always throws a value of 1, because there is only 1 row returned per customer. To fix this, you can create a calculated field on your dimension like:
LOOKUP(MAX([Customer Name]),0) and use this field in the filter instead of the raw dimension filter (this is a table calculation as well). So tableau just looks at the customer name that is selected in the filter retaining the values from the other table calculation and hence giving the unfiltered rank. Hope this helps!
Here is an article explaining the order of operation in Tableau: Tableau's Order of Operations
