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 (opens in a new tab) property. You can specify an expression with criteria in conditions, or a specific value in values.
pivot.filter({
operation: "and", // and | or
conditions: [
{ name: "Sales Quarter", criteria: "value >= 2" },
{ name: "Brand name", values: ["Kia", "Hyundai"] }
]
});pivot.filter({
operation: "and", // and | or
conditions: [
{ name: "Sales month", criteria: "value >= 9" },
{ name: "Car type", values: ["Midsize"] }
]
});pivot.resetFilter();