Exclude Items
You can choose to remove individual items that
are not needed in your analysis.
When you exclude items, you exclude the value from the Subtotal (included) subtotal, as well as hide the row or column from view. Its value is now rolled up into the Subtotal (excluded) subtotal.
If you want to include the values of hidden rows and columns, use the Hide command.
Note: You cannot exclude items in a selection-based set.
Procedure
Right-click a row or column and click Exclude.
Tip: To show excluded items, select the set that
contains the excluded item, open the properties pane, click Excluded
Items, and then click Include (name
of excluded item) or Include All.