.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.
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.
