Concat values from one field

[#1]

Hi,

I'm facing a problem with concat few values from one field.

EX: I have two column called State,Value and those values are like...

State,Value

A,10

B,5

C,12

D,8

I want

State,Value

A/B,15

C/D,20

Can any one please tell me how to get this done.

Thanks in Advance.

Regards,

Arjun

[Kushal_Chawda]

There is no difference but I can make difference like below

Front end solution

create the straight table

Dimension:

ID

Expression:

1) State - concat( distinct State,'/')

2) Value - sum(Value)