calculate grouped percentages

noone_santosh — Tue, 07 Oct 2014 02:28:59 GMT

Hi,

I used TABLES>SUMMARY to group a table by year and position to get N rows. I want to calculate % by year (COL 3) in below table. But when I select % Total statistic it gives me % of all observations(I get COL 4). I don't see a % Total statistic on the group variable. Can anyone tell how I can calculate COL 3 of below table?

YEAR	POSITION	N ROWS	% by year	% Total
2002	Catcher	70	8.24	4.18
2002	Designated Hitter	6	0.71	0.36
2002	First Baseman	46	5.42	2.75
2002	Outfielder	160	18.85	9.55
2002	Pitcher	411	48.41	24.54
2002	Second Baseman	56	6.60	3.34
2002	Shortstop	46	5.42	2.75
2002	Third Baseman	54	6.36	3.22
2003	Catcher	73	8.84	4.36
2003	First Baseman	55	6.66	3.28
2003	Outfielder	145	17.55	8.66
2003	Pitcher	394	47.70	23.52
2003	Second Baseman	44	5.33	2.63
2003	Shortstop	63	7.63	3.76
2003	Third Baseman	52	6.30	3.10

Re: calculate grouped percentages

Mark_Bailey — Wed, 08 Oct 2014 15:20:15 GMT

Did you select (check box) the Include marginal statistics option that appears under the list of data columns?

topic Re: calculate grouped percentages in Discussions

calculate grouped percentages

Re: calculate grouped percentages