5 Replies Latest reply on Aug 28, 2012 9:18 AM by Gordon Young

    Best way to band total dollars?

    Moises Mendoza

      I would like to group all the members into the following buckets based on their total dollar amount.

      <=  5000 then '< 5k'

      >   5000 and <= 24000 then '5k-24k'

      > 24000 and <= 40000 then '24k-40k'

      >  40000 then '40k+'

      What is the best way to do this?

       

      Thanks.

      Names.jpg