2 Replies Latest reply on Sep 26, 2012 6:31 AM by Matthew Reeve

    Equal Ranking

    Matthew Reeve

      Hi

       

      I've got a set of data where I have a calculation establishing what ranking a particular value is (using INDEX()) However, it is very common for values to be equal. In this situation, INDEX() doesn't handle equal values. In an ideal world, I would use a lookup to check against the previous value, if it is the same, to report the rank of the previous value. However Tableau doesn't appear to allow circular references like this.

       

      Does anyone have a solution or any suggestions?

       

      Thanks

       

      Matthew