COLUMN 1 CLOUMN 2 COLUMN 3 TOTAL
36 41 94 171
12 16 35 63
1 2 5 8
23 23 54 100
3.91 2.24 3.89 10.03
2.50 1.25 2.23 5.98
I need help to find if different rows of a cross tab can be summarized differently in the grand total. In the table above the first 5 rows all summarize in the total, the last 2 rows need to be an average of the 3 columns. 10.03 should be 3.35 and 5.98 should be 1.99. Is this possible.
Thanks,
Ed
36 41 94 171
12 16 35 63
1 2 5 8
23 23 54 100
3.91 2.24 3.89 10.03
2.50 1.25 2.23 5.98
I need help to find if different rows of a cross tab can be summarized differently in the grand total. In the table above the first 5 rows all summarize in the total, the last 2 rows need to be an average of the 3 columns. 10.03 should be 3.35 and 5.98 should be 1.99. Is this possible.
Thanks,
Ed