- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Calculation field subgroup count
Hello,
This is probably a newbie question, but I can't seem to find the answer. I am looking for a way to program a calculation field that would give me for each individual the total numbers of the subgroup to which he belongs. The subgroup is determined by 3 variables: Year of birth - Gender - Employment.
Example:
Row #1: 1930 - Woman - Nurse [17]
#2: 1930 - Woman - teacher [74]
#3: 1930 - Man - Plumber [49]
#4: 1930 - Woman - Nurse [17]
#5: 1930 - Man - Plumber [81]
#6: 1930 - Man - Lawyer [15]
#8: 1930 - Woman - teacher [74]
…
#333: 1931 - Woman - Nurse [63]
#334 1931 - Woman - teacher [134]
#335 : 1931 - Man - Plumber [128]
#336: 1931 - Woman - Nurse [63]
etc
I could of course get this information by doing a crosstab, but I need to have it in a column for each of the individuals in my population in order to calculate indicators.
Thanks a lot for your help..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Calculation field subgroup count
I am confused as to what you want the output to look like. For the data you supplied, what would the output look like?
- « Previous
-
- 1
- 2
- Next »