topic Display all grouping column values in Tabulate in Discussions

Display all grouping column values in Tabulate

ben_ph — Fri, 09 Jun 2023 18:12:03 GMT

Hi, I'm wondering if there is a way to show a value in every row of a grouping column when using Tabulate. For example in the table generated from the below, show a value for each row for country.

NamesDefaultToHere(1);
dt = Open("$SAMPLE_DATA/Car Poll.jmp");
obj = dt << Tabulate(
    Add Table(
        Column Table(Grouping Columns(:sex, :marital status)),
        Row Table(Grouping Columns(:country, :size))
    )
);

Re: Display all grouping column values in Tabulate

Georg — Wed, 02 Mar 2022 22:08:41 GMT

If you "Make into data table" under red triangle menu of tabulate, the resulting data table would have a country in every row. Perhaps this helps?

Re: Display all grouping column values in Tabulate

txnelson — Thu, 03 Mar 2022 01:40:48 GMT

If you make the Tabulate table into a data table, you can then create a new window and use a Table Box() to create your desired output

Data Table from Tabulate

Script to generate the Window with the Table Box()

Names Default To Here( 1 );
dt = Current Data Table();
New Window( "table",
	tb = Table Box(
		String Col Box( "Country", dt:country << get values ),
		String Col Box( "size", dt:size << get values ),
		Col Span Box(
			"Sex",
			Col Span Box(
				"Female\!nMarital Status",
				Number Col Box( "Married", dt:Female Marital Status married << get values ),
				Number Col Box( "Single", dt:Female Marital Status single << get values )
			),
			Col Span Box(
				"Male\!nMarital Status",
				Number Col Box( "Married", dt:male Marital Status married << get values ),
				Number Col Box( "Single", dt:male Marital Status single << get values )
			)
		)
	)
);

What the output looks like