1 Reply Latest reply on Mar 6, 2013 9:01 AM by Tracy Rodgers

    how to turn rank value as calculated to a string (dimensional value)

    Joe Smith

      James Bakers wonder guide on how to calculate the rank according to a given variable using "calculated field" scripting:

      http://community.tableau.com/thread/108967

       

      The script to calculate standard rank is:

      IF ISNULL(SUM([Measure])) THEN

        NULL

      ELSE

        IIF(SUM([Measure]) == LOOKUP(SUM([Measure]), -1),

            PREVIOUS_VALUE(1), INDEX(), 1)

      END

       

      I want to ask how to turn this rank value as calculated to a String or a dimensional value.

       

      I sense a slight modification of the above script will do the magic....

       

      Thanks in advance!