Create Filter On Pivot Table

Evaluating the Excel product and I have a nice Pivot Table working; but I cannot seem to figure out how to add a filter to the table? Thanks, -Chuck

What I'm really looking for is more like this. Here's my pivot table created via code: ![Pivot Table via ComponentPro][1] What I'd like to do is have the "Store Num" field as a filter, similar to what the next image shows. Is this possible? -Thanks, -Chuck ![enter image description here][2] [1]: https://i.imgur.com/aGIOogj.png [2]: https://i.imgur.com/qPBitaX.png

After creating your PivotTable, you can use the following code to apply one or more filters: var field = pivotTable.Fields[2]; // Apply value filter field.PivotFilters.Add(PivotFilterType.ValueLessThan, field, "999", null);