pie chart?

[Anonymous]

Hi i want create bucket for pie chart

like

if client false between 

1  1a

2  2-5a

3 6-10a

4 11-15a

5 16-20a

6 >20a

expression is    avg(sales)

how to create this ?

[Anonymous]

Calculated dimension:

if(avg(sales)<=1, '1a',
if(avg(sales)<=5, '2-5a',
if(avg(sales)<=10, '6-10a',
if(avg(sales)<=15, '11-15a',
if(avg(sales)<=20, '16-20a', '>20a')))))

(Re-count my parenthesis...)