Flexmonster - Pivot Table demo

Demos

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

new Flexmonster({
  container: "#pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  width: "100%",
  height: 430,
  toolbar: true,
  report: {
    dataSource: {
      filename: "data/sales.csv"
    },
    slice: {
        "rows": [
            {
                "uniqueName": "[Measures]"
            },
            {
                "uniqueName": "Category",
                "levelName": "Product Name"
            },
            {
                "uniqueName": "Customer"
            }
        ],
        "columns": [
            {
                "uniqueName": "Month"
            }
        ],
        "measures": [
            {
                "uniqueName": "Revenue",
                "aggregation": "sum",
                "format": "2sfou03a"
            }
        ],
        "expands": {
            "expandAll": true
        },
        "drills": {
            "drillAll": true
        }
    },
    conditions: [{
      formula: "#value < 2500",
      measure: "Revenue",
      format: {
        backgroundColor: "#df3800",
        color: "#FFFFFF"
      },
      isTotal: false
    }, {
      formula: "#value > 20000",
      measure: "Revenue",
      format: {
        backgroundColor: "#00A45A",
        color: "#FFFFFF"
      },
      isTotal: false
    }],
    formats: [{
      name: "2sfou03a",
      thousandsSeparator: ",",
      decimalSeparator: ".",
      decimalPlaces: 2,
      currencySymbol: "$",
      currencySymbolAlign: "left",
      nullValue: "",
      textAlign: "right",
      isPercent: false
    }]
  }
});