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 |
