My question is as follows: Suppose I have a data set where I have 4 fields
- Amount (metric 1)
- Sell Price (metric 2)
These 4 fields are displayed in a table in my Tableau dashboard. When I click on any item in the table, I would like text at the top to display the rank of both of the metrics and the Unique count of the metrics in my table as well as their values.
e.g. 'Amount = 32,500: Ranked 4 out of 342, Sell Price = $2.5: Ranked 2 out of 6' (I only have 6 differing Sell prices)
I would also like the implementation to be dynamic, so as when I filter on the date, the result would adjust to suit e.g. 'Amount = 32,500: Ranked 1 out of 10, Sell Price = $2.5: Ranked 1 out of 4'
I have tried using the RANK function, but whenever I click on the row in my table, it effectively filters out all of the other data and sets the rank to 1.
Is there a way to do this?