Add calculated measure with individual property
Calculated measures
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
let pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
data: getData()
},
slice: {
rows: [{
uniqueName: "Country"
}],
measures: [{
uniqueName: "Revenue",
formula: "sum('Quantity') * sum('Price')",
individual: false
},
{
uniqueName: "Revenue (individual)",
formula: "sum('Quantity') * sum('Price')",
individual: true
}
]
}
}
});
function getData() {
return [{
"Quantity": 7,
"Price": 100,
"Country": "Canada"
},
{
"Quantity": 5,
"Price": 200,
"Country": "USA",
}
]
}