Using showFilter option on the grid
Options
by Flexmonster Pivot Table
HTML
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<button onclick="hideFilterRows()">Hide filters</button>
<button onclick="showFilterRows()">Show filters</button>
<div id="pivot-container"></div>
CSS
@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);
JavaScript
let pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
filename: "data/data.csv"
},
slice: {
columns: [{
uniqueName: "Color",
}],
measures: [{
aggregation: "sum",
uniqueName: "Price"
}],
rows: [{
uniqueName: "Category"
}],
reportFilters: [{
uniqueName: "Country"
}],
},
"options": {
"viewType": "grid",
"showReportFiltersArea": true
}
}
});
function hideFilterRows() {
pivot.setOptions({
grid: {
showFilter: false
}
});
pivot.refresh();
}
function showFilterRows() {
pivot.setOptions({
grid: {
showFilter: true
}
});
pivot.refresh();
}