3 Replies Latest reply on Apr 1, 2016 9:50 AM by Joe Oppelt

    Rank calculation - a way to fix the ranked number ?

    yao fu

      Hi Tableau gurus,

       

       

      I need to rank the  people by "Balance Amt". The ranking number is given based on all population of 59 people.  But if I only select couple from the population, the ranking will change accordingly. however, I don't want it to change, and always show the its' ranking in the total population.

       

       

      Calculation filed is: rank(sum([Balance Amt])) 

       

      Any help is appreciated!

       

      Thank you,

      Flora