Exclude rows from a custom group total
In dynamic tables custom groups, you can exclude one or more rows from the accumulative balance of the group.
The balance in the Total row for the custom group is then updated to excluded the specified rows from the total group balance.
To exclude one or more rows from a custom group total:
-
Select the table.
-
Select More actions () | Edit Dynamic Table.
-
Locate the custom group where you want to exclude rows.
-
If the group is not expanded, select the Expand icon () to expand it.
-
Select the row that you want to exclude from the accumulative balance of the group.
-
Select Subtract fromTotal icon ().
-
Repeat Steps 5 and 6 for all the rows that you want to exclude.
-
Select Save or Save & Close.
Icons for table options display on the right.
The table opens in edit mode.