AGGR Help

[SonOfJeffGoldblum]

Hello,

I need help with what seems easier than it should be. I have a bar chart that I want to display the number of speakers we have had.

Right now, we have current data for 2019 but no previous years, yet in the dataset dates are shown for previous years.

We have 10 group talks, with each talk a different topic. What shows now is only what topic you are on with no tally of having completed previous topics. There is no breaking order. Would I be using AGGR() to figure out that if I did speech 10, I also did 1-9; speech 9 I did 1-8; speech 8 I did 1-7 and so on? This would then for each person put a tick mark in each topic bucket where if 10 people completed all 10, each topic for them would also have a tick mark of those being completed.

[Channa]

you have to work with P(),E() 

union * 

[SonOfJeffGoldblum]

Thank you Channa,

How would you write this if I may ask for an example where a tally for the current completion and all previous are placed within their own bucket?

Person	Current Count	Completed	Goal Count
A	1	5	5
B	1	10	10
C	1	1	1
D	1	2	2
E	1	4	4