Add calculated measure with individual property
Calculated measures
by yahmed
HTML
<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<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: {
data: [
{
"Country" : "Canada",
"Amount" : 36,
"Price" : 174
},
{
"Country" : "Canada",
"Amount" : 44,
"Price" : 225
}
]
},
slice: {
rows: [
{
uniqueName: "Country"
}
],
measures: [
{
uniqueName: "Price",
aggregation: "sum",
active: true
},
{
uniqueName: "Overall price",
formula: "sum('Price') * sum('Amount')",
individual: false,
caption: "Overall price",
active: true
}
]
}
}
});