Yes you would have to run separage Summary Platforms and then Join them together to get what you want, or you could run a Tabulate Platform and get what you want in one step.
![txnelson_0-1673652035752.png txnelson_0-1673652035752.png](https://community.jmp.com/t5/image/serverpage/image-id/49068i7D2EAA9A5AF07B21/image-size/medium?v=v2&px=400)
![txnelson_1-1673652071784.png txnelson_1-1673652071784.png](https://community.jmp.com/t5/image/serverpage/image-id/49069i50545DA79FAD0EB8/image-size/medium?v=v2&px=400)
Names Default To Here( 1 );
dt = New Table( "year/day",
add rows( 200 ),
New Column( "Airline",
character,
set each value(
aList = {"Delta", "Northwest"};
aList[Random Integer( 1, 2 )];
)
),
New Column( "day",
character,
set each value(
dList = {"Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"};
dList[Random Integer( 1, 7 )];
)
),
New Column( "n", ordinal, set each value( Random Integer( 1, 12 ) ) )
);
tab =Tabulate(
Add Table(
Column Table( Grouping Columns( :day ) ),
Column Table( Grouping Columns( :n ) ),
Row Table( Grouping Columns( :Airline ) )
)
);
tab<<make into data table;
Jim