JSON meta object

Data source

by Flexmonster Pivot Table

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 jsondata = [{
  "Country": {
    "type": "string",
    "dimensionUniqueName": "Area"
  },
  "City": {
    "type": "string",
    "dimensionUniqueName": "Area"
  },
  "SaleQty": {
    "type": "string",
    "caption": "Sale Qty",
    "dimensionUniqueName": "Measure"
  },
  "TotalAmount": {
    "type": "number",
    "caption": "Total Amount",
    "dimensionUniqueName": "Measure"
  }
}, {
  "Country": "Canada",
  "City": "Toronto",
  "SaleQty": 174,
  "TotalAmount": 22
}, {
  "Country": "USA",
  "City": "Los Angeles",
  "SaleQty": "250",
  "TotalAmount": 19
}];

var pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  width: "100%",
  height: 430,
  toolbar: true,
  report: {
    dataSource: {
      data: jsondata
    },
    options: {
      grid: {
        type: "flat"
      }
    }
  }
});