Help with an aggr

[Anonymous]

Assuming I have the following table:

Activity_ID	Date	ActivityType_ID	Time Period	Percentage
1	02-04-2018	6	10-14	0.5
2	02-04-2018	6	10-14	0.5
3	02-04-2018	9	14-16	0.25
4	03-04-2018	6	10-14	0.5
5	03-04-2018	11	14-18	0.5
6	04-04-2018	6	10-14	0.5
7	04-04-2018	6	10-14	0.5
8	04-04-2018	6	10-14	0.5
9	04-04-2018	6	10-14	0.5
10	04-04-2018	6	10-14	0.5
11	04-04-2018	6	14-18	0.5
12	04-04-2018	6	14-18	0.5

I need an Aggr formula that would produce a virtual table that's something like this:

Activity_ID	Date	ActivityType_ID	Time Period	Percentage
1	02-04-2018	6	10-14	0.5
3	02-04-2018	9	10-14	0.25
4	03-04-2018	6	10-14	0.5
5	03-04-2018	11	14-18	0.5
6	04-04-2018	6	10-14	0.5
11	04-04-2018	6	14-18	0.5

Further explanations:

The output table of the Aggr formula takes all activity_IDs that have different Time Periods and ActivityType_IDs and keeps the Dates correlated

[sunny_talwar]

What is the end goal that you are trying to achieve here?

[Anonymous]

Do a Sum on the Percentage field of the aggr table

[sunny_talwar · Accepted solution]

How about this

Sum(Aggr(Percentage, Date, ActivityType_ID, Time Period))

[Anonymous]

That's it! Thank you!