Sum with different conditions

[Lean_Sawko]

Hi everyone,

I want your help for this silly question, I want to find the best logic to follow up here. So, as you can see I want to sum([VALUE]) for each [COUNTRY] and to give me the below mockup. 

 

I could do a formula but there are many countries and cities so, I just can't make a manual formula e.g WHEN [COUNTRY] = "ARGENTINA"...

what do you recommend to create a simple output summarizing by country?

Thanks 

[Jonathan-Sherman · Accepted solution]

Hi @Lean_Sawko,

You can use a summarise tool for this, simply group by your country field and sum the value field.

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan