Forum Discussion
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 be pulled onto a different table. Currently i have the total by cohort being calculated in a matrix table but need to do this as a seperate measure or column.
| Cohort | Count of People ID |
| Cohort 1 | 28 |
| Cohort 2 | 15 |
| Cohort 3 | 26 |
| Cohort 4 | 74 |
| Cohort 5 | 65 |
| Cohort 6 | 23 |
| Cohort 7 | 5 |
| Cohort 8 | 10 |
| Cohort 9 | 9 |
| Cohort 10 | 11 |
| Total | 266 |
| Cohort 1- 28 |
| Cohort 2- 15 |
| Cohort 3- 26 |
| Cohort 4- 74 |
| Cohort 5- 65 |
| Cohort 6- 23 |
| Cohort 7- 5 |
| Cohort 8- 10 |
| Cohort 9- 9 |
| Cohort 10- 11 |
thanks for any help
6 Replies
Not sure I got it completely
GT = calculate(sum(Table[Count of People ID]),all(Table))
New column= Table[Cohort] &" " & Table[Count of People ID])
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.
