Use the Data Filter to interactively select complex subsets of data, hide these subsets in plots, or exclude them from analyses. For example, look at profit per employee for computer and pharmaceutical companies.
1.
|
2.
|
3.
|
4.
|
Click OK.
|
5.
|
From the red triangle menu for profit/emp, select Display Options > Horizontal Layout.
|
Distribution of profit/emp
6.
|
Turn on Automatic Recalc by selecting Redo > Automatic Recalc from the red triangle menu for Distributions.
|
7.
|
8.
|
10.
|
To filter out the Pharmaceutical companies from the Distribution results, and include only the Computer companies, click the Computer box in the Data Filter window.
|
Conversely, to change the Distribution results to include only the Pharmaceutical companies, click the Pharmaceutical button on the Data Filter window.