How can group the dimensions

Mon, 09 Nov 2015 14:25:57 GMT

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

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

Re: How can group the dimensions

maxgro — Mon, 09 Nov 2015 17:29:21 GMT

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);