Hi Experts,
I have a table (excel spreadsheet) with following fields:
ID (char)
Agecat (char)
Gender (char)
Indicator (integer)
ID Agecat Gender Indicator
1 A F 0
2 B F 1
3 A F 1
4 C F 0
5 C F 1
6 B M 0
7 B M 1
8 D M 1
9 C M 0
10 C M 1
1.I need to show a percentage of Gender By Age for those who have an indicator =1.
2. I need this percentage among all other members of the table.
3. I need to represent it in a PIE CHART format
Could you please give me a hand?
Thank you in advance,
Irin
I have a table (excel spreadsheet) with following fields:
ID (char)
Agecat (char)
Gender (char)
Indicator (integer)
ID Agecat Gender Indicator
1 A F 0
2 B F 1
3 A F 1
4 C F 0
5 C F 1
6 B M 0
7 B M 1
8 D M 1
9 C M 0
10 C M 1
1.I need to show a percentage of Gender By Age for those who have an indicator =1.
2. I need this percentage among all other members of the table.
3. I need to represent it in a PIE CHART format
Could you please give me a hand?
Thank you in advance,
Irin