Hi there,

I have a dataset of 200'000 observations consisting of customer IDs for 14 years. I have 8 binary variables that represent a group that customers are a part of. Now I would like to know for each of the 14 years seperately how many customers belong to any of the 8 groups. So for example in year one 80% are group 1, 5% group two and so on. I hope there is a way so that I don't have to do each year by itself but all in one go.

Any help is greatly appreciated.

Kind regards