How to Connect a Table to a Pasted R Table

Sometimes you may want to make some minor edits to a table such as selecting only certain rows, sorting, or changing row labels. You can do this by connecting your table to a Pasted R table which allows for Data/Row/Column manipulation. This article describes how to connect a table...

...to a Pasted R table:

Requirements

A table

Method

In the toolbar, select Table > Paste or Enter Table.
In the object inspector, go to Data > Data Source > Data field and either click on the name of your table on the Page or select the table name from the dropdown.
[Optional]: Use the Data Manipulation to hide outputs and values with small sample sizes and more.
[Optional]: Use the Row/Column Manipulations to hide rows/columns, sort, and relabel headers.
[Optional]: Further customize the table using custom R code in Data > Show Advanced Options > R Code > Edit Code.