summarized sum for each row

[Jmarquez]

Hello,

I have a data set with information recorded dayly for different countrys.

My objective is to create a new row withing the data set that aggregates the data for Europe as the summ of all the countrys by day.

I would appreciate some help with this!

thank you in advance 

Jorge 

[mceleavey]

Hi @Jmarquez ,

Solution attached.

Hope this helps.

M.

[atcodedog05]

Hi @Jmarquez 

Here is my solution.

Workflow:

1. Using multi-row formula i am setting a group id for each Date

2. Using summarize tool to get sum for each data and max groupID

3. Setting area as Europe and Group ID as Max_GroupID+1

4. Join back with union

5. Sorting based on date and groupID.

Hope this helps 🙂

Edit : I guess me and @mceleavey 😅 ended up with same solution with slight difference.

[mceleavey]

@atcodedog05 great minds think alike 🙂

[Jmarquez]

thank you both for the quick response.

@mceleavey  

The solution is very interesting and almost covers my needs.

I may have left some aspects out because I tried to summarize the problem too much.

The problem I have is that not all areas have records for all days so the Id code does not match and I can't do the europe category.

Another aspect is that in some records I have information for Europe already calculated beforehand, so it would have to be added to the aggregation calculated (it does not seem a big inconvenience).

any idea about it ?

Thanks !

[mceleavey]

Hi @Jmarquez ,

without posting a representative sample of data it will be very difficult for us to see the problem.

M.