Subscribe Bookmark RSS Feed

calculate grouped percentages

noone_santosh

Community Member

Joined:

Oct 6, 2014

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?

     

YEARPOSITIONN ROWS % by year% Total
2002Catcher708.244.18
2002Designated Hitter60.710.36
2002First Baseman465.422.75
2002Outfielder16018.859.55
2002Pitcher41148.4124.54
2002Second Baseman566.603.34
2002Shortstop465.422.75
2002Third Baseman546.363.22
2003Catcher738.844.36
2003First Baseman556.663.28
2003Outfielder14517.558.66
2003Pitcher39447.7023.52
2003Second Baseman445.332.63
2003Shortstop637.633.76
2003Third Baseman526.303.10
1 REPLY
markbailey

Staff

Joined:

Jun 23, 2011

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

Learn it once, use it forever!