Adding Field within Fields / SUMIF Bar Chart

[300sss300]

I have 3 Fields lets say Name1 Name2 and Amount. 

Q1) How I can add 4th field which is Name1 = Name2

Q2) I want to show in Bar Chart only those amounts If Name1=Name2. Expression in this case will be SUM (Amount)...... What will be the Dimention ??? 

Regards

[300sss300]

Already done with 2nd Question. Just need Ans for Q1.

[Anonymous · Accepted solution]

you can try sth like:

Take Name1, Name2 both as a dimension

Expreassion:  =sum(if(Name1=Name2, Amount))

[300sss300]

Thanks.

What about Q1.

I mean what if I want to set this condition "Name1=Name2"  as new field. Like Name1 Name2 and Amount so that there should be 4 fields.