Age grouping

hello,

i have age dimension contains age of custemers.  i want make age grouping like

21-26  (21-23, 23-26)     
27-35  (27-30, 31-35)
36-45
46-55
56-59
60++

the range has no pattern. there smart way make the age group.

thanks
alex
 

add named calc on customer table dsv
e.g
 case
    when age between 21 , 23 '21-23'
    when age between 24 , 26 '24-26'
    ....
    when age >=60then '60++'
    else 'bellow 21'
end


      

SQL Server  >  SQL Server Analysis Services