Microsoft Office Tutorials and References
In Depth Information
When you select a table for import, you can give it a friendly name, which is the name that
PowerPivot uses for the table after it has been imported. If you like, you can filter to reduce
the number of rows you have to read from the table. Filtering is useful when you face very
big tables and you are interested in the analysis of only some of the rows.
To access the filtering dialog box (see Figure 5-5), you should use the Preview & Filter button.
FIguRE 5-5 Previewing and filtering a table.
To limit the rows in a table, you can apply two different kinds of filters:
■ Colum filtering You can choose a selection of all the columns of the table for loading.
This is convenient when the source table contains technical columns, which are not
useful for our analysis. To select or remove a column, you need to use the small check
box that appears before each column title in the grid.
■ Data filtering You can also choose to load only a subset of the rows of the table,
specifying a condition that filters out the unwanted rows. In Figure 5-6, you can see
the data filtering dialog box open for the Name column.