Override default number format with setFormat API call
Number formatting
by Flexmonster Pivot Table
HTML
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<button onclick="setFormat()">Set default format</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"
}
}
});
function setFormat() {
var format = {
name: "",
currencySymbol: "$",
thousandsSeparator: ","
};
pivot.setFormat(format);
pivot.refresh();
}