Creating a single row with the sum of several rows with the same value in a reference column

[Wonder]

Hi,

I have the following query results:

I want to create one row for China with the sum of all the values for China on a given day. In this case the row results would look like this:
Western Pacific   |     China     |     278    |      1/20/2020

How do I alter my query to acheive this?

[Wonder]

I have the following query results:

I want to create one row for China with the sum of all the values for China on a given day. In this case the row results would look like this:
Western Pacific   |     China     |     278    |      1/20/2020

How do I alter my query to acheive this?

[Mariusz · Accepted solution]

Hi @Wonder 

You can use Group By in query Editor as per below.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn