1.
Select Help > Sample Data Library and open Companies.jmp.
2.
Select Analyze > Distribution.
3.
Select Profits ($M) and click Y, Columns.
4.
6.
Click Type and click Add.
7.
In the Type box, click Pharmaceutical to see only their profits, then click Computer to see only their profits.
Figure 8.4 Local Data Filter Showing Pharmaceutical Profits
Figure 8.5 shows the difference between counting and omitting excluded rows. When the excluded rows are counted, the Local Data Filter shows 20 rows that contain the value “Computer”. When the excluded rows are omitted, only 16 rows contain “Computer”.
Figure 8.5 Counting (Left) and Omitting (Right) Excluded Rows

Help created on 10/11/2018