Change measure selected in the slice via API
Slice configuration
by Flexmonster Pivot Table
HTML
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<button id="buttn" onclick="changeMeasure()">Change measure</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/",
width: "100%",
height: 430,
toolbar: true,
report: {
dataSource: {
filename: "data/data.csv"
},
slice: {
rows: [{
uniqueName: "Color"
}],
columns: [{
uniqueName: "[Measures]"
}],
measures: [{
uniqueName: "Price",
aggregation: "sum",
format: "currency",
active: true
},
{
uniqueName: "Quantity",
aggregation: "sum",
active: false
}
]
},
formats: [{
name: "currency",
decimalPlaces: 2,
currencySymbol: "$",
currencySymbolAlign: "right"
}],
}
});
function changeMeasure() {
var report = pivot.getReport();
report.slice.measures = [{
uniqueName: "Quantity",
aggregation: "sum",
active: true
}];
pivot.setReport(report);
}