
# Pivot Filtering

Only data that satisfies the conditions in the original data can be configured as a pivot.

#### Filtering settings
Specify filter conditions with the conditions property and specify the operation method between conditions with the [operation](http://help.realgrid.com/api/types/FilteringOptions/) property.
You can specify an expression with criteria in conditions, or a specific value in values.

<GridView demo='pivotguides/04-pivotFiltering/01' height={700}/>

```js
pivot.filter({
     operation: "and", // and | or
     conditions: [
         { name: "Sales Quarter", criteria: "value >= 2" },
         { name: "Brand name", values: ["Kia", "Hyundai"] }
     ]
});
```

<GridView demo='pivotguides/04-pivotFiltering/02' height={700}/>

```js
pivot.filter({
     operation: "and", // and | or
     conditions: [
         { name: "Sales month", criteria: "value >= 9" },
         { name: "Car type", values: ["Midsize"] }
     ]
});
```

```js
pivot.resetFilter();
```

#### API LINK

[filter()](http://help.realgrid.com/pivotApi/RealPivot/filter/)