summarized sum for each row

Question

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 · Answer

Hi @Jmarquez ,

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

M.

Jmarquez · Answer

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 · Answer

@atcodedog05 great minds think alike 🙂