Flexmonster Demo: Add calculated value

by Flexmonster Pivot Table

HTML

<script src="https://s3.amazonaws.com/flexmonster/2.2/flexmonster.js"></script>
<div id="pivot-content"></div>

JavaScript

var jsonData = [{
   "Color": "green",
   "M": "September",
   "W": "Wed",
   "country": "Canada",
   "state": "Ontario",
   "city": "Toronto",
   "Price": 174,
   "Quantity": 22
 }, {
   "Color": "red",
   "M": "March",
   "W": "Mon",
   "Time": "1000",
   "country": "USA",
   "state": "California",
   "city": "Los Angeles",
   "Price": 1664,
   "Quantity": 19
 }, {
   "Color": "red",
   "M": "January",
   "W": "Mon",
   "country": "Canada",
   "state": "Quebec",
   "city": "Montreal",
   "Price": 1190,
   "Quantity": 292
 }];

 function setPivotReport() {
   var report = {
     dataSourceType: "json",
     data: jsonData,
     rows: [{
       uniqueName: "M"
     }],
     columns: [{
       uniqueName: "country"
     }, {
       uniqueName: "[Measures]"
     }],
     measures: [{
       uniqueName: "Quantity"
     }, {
       uniqueName: "Total",
       caption: "Total",
       formula: "sum('Price') * sum('Quantity')",
       calculated: true
     }],
     configuratorActive: false,
     viewType: "grid",
   };
   flexmonster.setReport(report);
 }

 flexmonster.embedPivotComponent("https://s3.amazonaws.com/flexmonster/2.2/", "pivot-content", "100%", "600", {
   licenseKey: "Z53G-1T1WC3-1V1M-0L12-2M0A-1233-1I0Y-2Y2Q-1903-322S-0T2C-1I",
   jsPivotCreationCompleteHandler: setPivotReport
 }, true);