How can group the dimensions

[#1]

Hi team,

Need help from experts,

I want to know how to group one of the column and get results accordingly.

For example

Name	Production
1 2 3 4 5 6 7 8 9 10 11 12	927 836 506 706 937 712 872 839 729 776 881 868 750 717 880 725 557 991 525 797 559 614 1000 771

Lets say I want to present the above production from 1 to 5 individually  and then 6,7,8,9 would be clubbed as 6+

Please confirm what would be the syntax in expression or we would give condition in dimension.

May be new field to be created in scripting.

Kindly suggest at earliest

Regards

[maxgro]

LOAD

  *,

  if(Name<6,Name, if(Name<10, '6+', 'Other'))as NameGroup

INLINE [

Name Production Sale

1 927 836

2 506 706

3 937 712

4 872 839

5 729 776

6 881 868

7 750 717

8 880 725

9 557 991

10 525 797

11 559 614

12 1000 771

] (delimiter is spaces);