Notice the filter button near the top of the data pilot table. This lets you filter the data upon which the data pilot table is based.

This filter works just like the standard filter feature we saw earlier. Let's say we want to only show data for plants categorized as conifer trees. Select category as the filter field name, a condition of “equals” and select conifer trees from value list box.

Instead of showing data for all plants the data pilot table only calculates totals for conifer trees.

Earlier in this tutorial we covered how to use the standard filter screens in detail. Filtering the data pilot table works the same way.

If you want to remove the filter from a datapilot table click the filter button, change the field name to none and click OK.