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 on a page or a table output in the Report tree

Method

With the table selected, go to the General tab in the object inspector and copy the Name.
In the toolbar, go to Calculation > Custom.
In the R code editor, paste the table's name that was copied at Step 1.
Click Calculate.
[Optional]: Use the Data > Rules in the object inspector to manipulate the R table (hide rows/columns with small sample sizes, sort, relabel rows/columns, and more).
[Optional]: Further customize the table using custom R code in Data > R Code > Edit Code.