How do I create a Calculated Dimension to do Stratification in a Straight Table

[cliff_clayman]

I am trying to make a stratification chart to show different "buckets" for expenditures.  I would like to have buckets of 0-500, 500-1000, 1000-2000, 2000-5000, 5000+.  The field that I am doing this on is called Expense Amount.  I would like a calculated dimension for this.  How can this be done?

[MK_QSL]

This is similar to this..

class function Label

Creating buckets

Buckets

[Anonymous]

class in the script and chart  or Intervalmatch in the script

LOAD *, class(Age, 10, 'age') As Agegroup; LOAD * INLINE [ Age, Name 25, John 42, Karen 53, Yoshi];

or

Inner Join IntervalMatch (Date,Key) LOAD FirstDate, LastDate, Key resident Key;