I want the Rank() function to dynamically calculate the rank when filters are selected.
Is there a way to "compute" a statistical or a ranking function after the filters have been applied?
Let's say that I have a table column with 4 values:1, 2, 3 and 4.
If I create a calculated column asking for the max value, I get 4 which is expected.
Now If I put a filter on those values and filter out the value 4, I still get 4 as the max value.
What I would like is to get 3 as the max value which is 4.
