Grouping Calculated Dimensions

[#1]

Hi. I have a calculated dimension called Average Spend. I have calculated the average spend per customer using the aggr function. The measure on the Y axis is No Of Customers. What I want to do is to group the Average Spend so that the first bar is 0-200, the second 201-400, the third 401-600 etc. I cannot see a way of doing this. Can anyone help

[#2]

You may just try as below:

if(aggr(sum(average_spend),Customer)<=200,'0-200',
          if(aggr(sum(average_spend),Customer)<=400,'201-400',
          if(aggr(sum(average_spend),Customer)<=600',401-600','>600')
)
)

Only problem is that this is practical only if number of groups is less number. If you want one such grouping propably you can do this at script level. But generally the groups will be a fixed number

Regards,

Kiran.

[#3]

Many thanks Kiran - this worked.