How to Select Specific Rows and Columns to Appear in a Table

Introduction

This article describes how to go from a default table output:

To a table that shows only selected rows and columns:

Requirements

A Displayr document with a data set.

Method

1. Create a new table by dragging a variable onto the page or select an existing table.
2. With the table selected, go to Anything > Table > Select. 
3. From the object inspector, go to Inputs > TABLE 1 and select which Rows to include and Columns to include in the table:
   

Note, the default selection option is Selecting options below whereby every row and column apart from NET and SUM will be selected by default. You can select and deselect the items you wish to include.

You can also choose other Select rows/columns by options. Below are the options available for categorical data:

• Control or output from Page(s) - If this method is chosen, a drop-down called Control to select row(s)/column(s) appears, which can be used to supply a Calculation (via Calculation > Custom Code) or Control box (via Anything > Page Design > Control) containing the row/column labels to include.
• First rows/columns - If this method is chosen, a numeric field called Number of rows/columns to select appears, which specifies the number of rows/columns from the first to include; eg, specify 3 to show only the first three rows/columns of the table. Note, you can also access this option directly from the toolbar via Calculation > First.
• Last rows/columns - Similar to First rows/columns, except for selecting rows/columns from the bottom of the table. Note, you can also access this option directly from the toolbar via Calculation > Last.
• Range - Use this option to specify a numeric range of indices to include. When selected, a text box Range appears for specifying the row/column numbers to include. Ranges are specified with a hyphen and multiple ranges can be separated by a comma; eg, "2-5,8,12-15".

See How to Select Specific Rows and Columns to Appear in a Date/Time Table for date-specific selection options and How to Switch Between Tables via a Control Box when selecting more than one table.

Note that the output table is an R table and will not perform the significance testing included with other tables.

4. OPTIONAL: Update Properties > APPEARANCE > Decimals and Number format as required.

See Also

How to Select Specific Rows and Columns to Appear in a Date/Time Table

How to Switch Between Tables via a Control Box