The column dimension of the TABLE statement creates a column for each
formatted value of Classrm. Nested within each column are columns that summarize
sales for the class. The first nested column, labeled
sum
, is the sum of sales for the row for the
classroom. The second nested column, labeled
ColPctSum
, is the percentage of the sum of sales for the row for the
classroom in relation to the sum of sales for all teams in the classroom.
The third nested column, labeled
RowPctSum
, is the percentage of the sum of sales for the row for the
classroom in relation to the sum of sales for the row for all classrooms.
The fourth nested column, labeled
RepPctSum
, is the percentage of the sum of sales for the row for the
classroom in relation to the sum of sales for all teams for all classrooms.
The last column of the report summarizes sales for the row for all classrooms.
classrm='Classroom'*(sum
colpctsum*f=pctfmt9.
rowpctsum*f=pctfmt9.
reppctsum*f=pctfmt9.)
all