Combine two rows as one

[Abhi999]

Hi i need your help to get output like below.

I have two fields

Name       Amount

Suresh     100

Mohan   200

Prathap 300

Sai            500

I want to combine Suresh and Sai as one, required output like below

Name                     Amount

Suresh+Sai           600

Mohan                   200

Prathap                300

[Taoufiq_Zarra]

@Abhi999  for example :

Data:

load if(Name='Suresh' or Name='Sai','Suresh+Sai',Name) as Name,Amount inline [
Name,Amount
Suresh,100
Mohan,200
Prathap,300
Sai,500
]
;

output:
noconcatenate

load Name,sum(Amount) as NewAmount resident Data group by Name;

drop table Data;

[Abhi999]

thank you, is it possible in front end instead of script.

[Taoufiq_Zarra]

@Abhi999 

In front :

Add dimension : =if(Name='Suresh' or Name='Sai','Suresh+Sai',Name)

Measure: =Sum(Amount)

[Abhi999]

thanks your quick response, i want to show Prathap and mohan aswell not only Suresh and Sai .

I am expecting below:

Suresh and Sai as on row and remaining as usual.

[Taoufiq_Zarra · Accepted solution]

attached qvw example

that's what I sent

[Abhi999]

Thank you Zarra, it works fine for me.

[Abhi999]

Is it possible to show 

Suresh and said seperate and suresh+Sai seperate ?

[Abhi999]

Using below we are able to combine Suresh and said show count. But I want to show Sai and Suresh seperatly and sures+Sai aswell.

 dimension : =if(Name='Suresh' or Name='Sai','Suresh+Sai',Name)

[Abhi999]

Using below we are able to combine Suresh and said show count. But I want to show Sai and Suresh seperatly and suresh+Sai aswell.

 dimension : =if(Name='Suresh' or Name='Sai','Suresh+Sai',Name)