Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);