2 Replies Latest reply on Jun 25, 2018 1:32 PM by Deepak Rai

    Creating an "Other" Row with a Calculated Field

    Valerie Nadi

      Hello!

       

      I'm a new Tableau user working on a dashboard displaying sales by customer. We have a long list of customers so I'd like to cut it off at a certain point and put everyone below a threshold in an "Other" bucket. I was trying to use a calculated field to do this, but seem to have some errors. Any suggestions/insights?

       

      IF [Sales] < 1000000 THEN 'Other'

      ELSE [Customer Name]

      END

       

      Thank you!

      Valerie