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,