Measure captions in flexmonster
Trying to override 'Sum of Price' label with a custom caption
by yahmed
HTML
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<div id="pivot-container"></div>
JavaScript
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 430,
toolbar: true,
report: {
dataSource: {
dataSourceType: "csv",
filename: "https://cdn.flexmonster.com/data/data.csv"
},
slice: {
columns: [{
uniqueName: "Color"
}],
rows: [{
uniqueName: "Country"
}, {
uniqueName: "[Measures]"
}],
measures: [{
uniqueName: "Price",
format: "currency",
caption: "Custom caption",
grandTotalCaption: "Custom total caption"
}, {
uniqueName: "Discount",
format: "currency"
},
{ uniqueName: "Count",
caption: "Distinct Price",
formula: "count('Price')"
}],
},
formats: [{
name: "currency",
currencySymbol: "$",
currencySymbolAlign: "left",
thousandsSeparator: ",",
decimalPlaces: 2
}]
}
});