Combining 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

[AshvitaKatkar]

Hi Abhi,

On which criteria your want to combine two rows as one???

Regards,

Ashvita

[Abhi999]

Hi Sawant,

No criteria nothing just want like this

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

[AshvitaKatkar · Accepted solution]

Hi Abhi,

Assuming you don't want to combine Mohan and Prathap you can execute following experience in frontend chart:

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

Measure: =Sum(Amount)

Regards,

Ashvita

[Abhi999]

Thank you Asvita, it works fine for me.