Disable the selection filter for a field (Custom data source API)
Mapping configuration
by Flexmonster Pivot Table
HTML
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<div id="pivot-container"></div>
CSS
@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);
JavaScript
const pivot = new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 430,
report: {
dataSource: {
type: "api",
url: "https://olap.flexmonster.com:9500",
index: "fm-product-sales",
mapping: {
"Category": {
filters: {
members: false
}
}
}
},
slice: {
rows: [{
uniqueName: "Category"
}],
columns: [{
uniqueName: "Color"
},
{
uniqueName: "[Measures]"
}],
measures: [{
uniqueName: "Price"
}]
}
},
reportcomplete: () => {
pivot.off("reportcomplete");
pivot.openFilter("Category");
}
});