1 In the data source dialog box,
click Data Options.
2 Click
the Subset tab.
2 Under
Include or Exclude,
choose one of the following:
§ Specify
which rows to include to base your subset on included rows.
§ Specify
which rows to exclude to base your subset on excluded rows.
3 Under
Specify Which Rows To
Include/Exclude, choose one of the following:
§ All
rows to include or exclude all rows.
§ Rows
that match and click Condition
to enter a condition to be met by included or excluded rows.
§ Brushed
rows to include or exclude brushed
rows.
§ Row
numbers and enter specific rows numbers to be included or excluded.
Use a colon (:) to denote an inclusive range. For example, enter 1 4 6:10 to signify the rows 1,4,6,7,8,9,10.
4 Click
OK.