Flexmonster - Pivot Table demo

by dpnminh

HTML

<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://code.jquery.com/jquery-2.2.4.min.js"></script>
<script src="https://cdn.flexmonster.com/2.3/flexmonster.js"></script>

<div id="pivot-container"></div>

JavaScript

var pivot = $("#pivot-container").flexmonster({
  componentFolder: "https://cdn.flexmonster.com/2.3/",
  width: "100%",
  height: 430,
  toolbar: true,
  report: {
    dataSource: {
      filename: "data/data.csv"
    },
    slice: {
      columns: [{
        uniqueName: "Color"
      }],
      rows: [{
        uniqueName: "Country"
      }, {
        uniqueName: "[Measures]"
      }],
      measures: [{
        uniqueName: "Price",
        format: "currency"
      }, {
        uniqueName: "Discount",
        format: "currency"
      }],
    },
    formats: [{
      name: "currency",
      currencySymbol: "$",
      currencySymbolAlign: "left",
      thousandsSeparator: ",",
      decimalPlaces: 2
    }],
    conditions: [{
      formula: "if(#value < 2000, 'trueStyle')",
      measure: "Discount",
      trueStyle: {
        backgroundColor: "#CCFFCC",
      }
    }, {
      formula: "if(AND(#value > 2000, #value < 4000), 'trueStyle')",
      measure: "Discount",
      trueStyle: {
        backgroundColor: "#FFFF99",
      }
    }],
    options: {
      configuratorActive: false,
      grid: {
      showHeaders: false,
      type: "flat"
      }
    }
  }
});
setTimeout(function(){
	var options = pivot.getOptions();
  var report = pivot.getReport();
  console.log(options);
  console.log(report);

  options.grid.showHeaders = true;
  pivot.setOptions(options);
  pivot.refresh();
  options = pivot.getOptions();
  console.log(options);
}, 10000);