This article describes how to use a rule to go from a table that contains a NET column:
To a table where the NET column is removed:
Requirements
A crosstab table created in Displayr.
Method
1. Select the table.
2. In the object inspector on the right, go to Data > RULES.
3. Select the Plus (+) > Modify Headers > Automatically Remove NET Column.
4. Click OK to apply the rule.
Note that there are other tools available in Dispalyr for doing the same thing but in a more transparent way:
- You can right-click on a category on a table and select Hide.
- When exporting to Office there is an option called Ignore NET and SUM for tables in the Advanced Options. This options is selected by default.
- For visualizations, there is an option under Data > Column Manipulations called Columns to ignore. The NET, Total, SUM are included in this option by default.
Technical Notes
If using this rule on a crosstab where there is a - Grid structured set in the Rows or Columns, care must be taken if using this table in custom R code. In this case, if a NET column is removed by the rule, the underlying structure of the table changes and custom R code referencing may break. It's recommended to remove the NET column in the R code directly in this case, see How to Remove a Row or Column from a Table Using R.
Next
Caveats and Limitations for Rules
How To Create a QScript To Insert a Custom Rule
How to Automatically Remove NETs from Table
How to Automatically Remove NET Row