Flexmonster Demo - Calculate individual values

by Iryna Kulchytska

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,
    "Svc Cd": 125
  }, {
    "Color": "red",
    "M": "March",
    "W": "Mon",
    "Time": "1000",
    "country": "USA",
    "state": "California",
    "city": "Los Angeles",
    "Price": 30,
    "Quantity": 19,
    "Svc Cd": 124
  }];

var report = {
  configuratorActive: false,
  data: jsondata,
  viewType: "grid",
  pages: [{uniqueName: "city"}],
  rows: [{uniqueName: "Color"}],
  columns: [{uniqueName: "[Measures]"}],
  measures: [{uniqueName: "Svc Cd"}, {uniqueName: "Formula #1", caption: "Formula #1", calculated: true, individual: true, formula: "if( sum('Svc Cd') == 124, 125, sum('Svc Cd'))", active: true}],
  formats: [{name: "", nullValue: "blank"}]
};

report.licenseKey = "Z53G-1T1WC3-1V1M-0L12-2M0A-1233-1I0Y-2Y2Q-1903-322S-0T2C-1I";

flexmonster.embedPivotComponent("https://s3.amazonaws.com/flexmonster/2.2/", "pivot-content", "100%", "600", report, true);