Combination of two dimension

[#1]

Group_operator	sum
10<10	2
10<20	3

Is there any way to combine 10<10 and 10<20 and get the sum of 5?

What i would want to achieve is the table below

Group_operator	sum
10<10-20	5

Please help!!

[#2]

Hi

Below Table 10<10-20 as group operator not possible..

If u want Sum = 5 then take either Text Object or check Total in pivot/straight table..

[#3]

i'm using pivot table. It is not possible to combine the two operator into one? No way to do it this way?

[#4]

Hi,

we can get sum of value 5 into ione row but we can't get 10<10-20 autometically. so that we need to add calculated dimension =if(SubField(Group_operator,'<',1)=10,'10<10-20')

PFA.

Regards,

Kabilan K

[#5]

Hi PFA,

U can use the below script

Load SubField(Group_operator,'<',1)&'<'&Concat(SubField(Group_operator,'<',2),'-') as Group_operator, Sum(Sales) as Sales Group by SubField(Group_operator,'<',1);

Load * Inline

[Group_operator,Sales

10<10,2

10<20,3

20<30,4

20<40,5];

PFA.