Class function: Possible to change the fist bucket only

[regowins]

Hi All,

Is it possible to change the first bucket the the class function? For example, I would like it to show 0-10  for the first bucket and then increments of 30 after  ( 10 - 30, 30-60 , 60-90...etc) .

Example:

Buckets	count person
0 - 10	1
10 - 30	2
30 - 60	5
60 - 90	1

I have attached a file with sample data if it is possible.

Thanks,

Ash

[maxgro]

maybe with an additional if

=if(aggr(Class(Sum(Sales),2),SalesPerson)<10, aggr(Class(Sum(Sales),10),SalesPerson), aggr(Class(Sum(Sales),2),SalesPerson))

[regowins]

Thanks, that gets me close.