Combine two values to one


First of all Hello World,

I am a newbie user of domo and would like to show my problem.

I've got an input table with customers and turnover and I would like to show the turnover by customer.

Some customers are the same but with different customer names for example :

CC Factory Inc. and CC Factory GmbH
In my chart I need a bar with CC Factory Cons, including the turnover of CC Factory Inc. and CC Factory GmbH

I tried "Replace Text" and it replaces all the customer names into one but my bar is still separted only with the same name.

Got anyone an idea.

Also tried "Value Mapper" but this function doesn't replace any name.

THX Peter