cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
hogi
Level XI

Tabulate - change format?

Tabulate is great to generate an overview table with a few mouse clicks.

 

How can I change the format of a tabulate report in my Dashboard?

  • rotate column titles -> vertical
  • reduce font size
  • change column titles - esp: split a column title into two lines
    (unfortunately, tabulate ignores line breaks in the column names)
  • change entries (replace text)
  • make grouping entries selectable (for copy & paste)
  • add a String Col Edit Box as an additional column
  • convert to a table box
1 REPLY 1
hogi
Level XI

Re: Tabulate - change format?


@hogi wrote:

unfortunately, tabulate ignores line breaks in the column names


same for Tables/Split which ignores everything including/after the first line break:

 

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

: sex << set name("1st line \!n 2nd line");

Data Table( "Big Class" ) << Stack(
	columns( :name, :"1st line 
 2nd line"n )
);