Forum Discussion
Solved
Count
Hi I have the below as a matrix table and i want to be able to combine the cohort and the total of people on the cohort so it looks like the bottom table and all the data is on one field that can...
Hi amitchandak
yes that is what I want to do however i need to do the count of the people ID.
So i have a table with people in that have an individual ID and then have a cohort 1- 10 next to them. So far I can put the cohort on the row of a matrix table and the peoplesID in the values which gives me how many people are on each cohort. I want to do a calculation to total up how many are on each cohort. If that makes sense
thanks
Can you share sample data and sample output. Mark me @ while sharing.