JSON data source

Data source

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

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

JavaScript

var jsonData = [
	{
		"supplier" : "x",
		"itemid" : 36,
		"item" : "Ontario",
		"salesorder" : 36,
		"available" : 174,
		"leadtime" : 22
	},
	{
		"supplier" : "y",
		"itemid" : 37,
		"item" : "Ontario",
		"salesorder" : 31,
		"available" : 193,
		"leadtime" : 36
	},
	];

var pivot = new Flexmonster({
	container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
		toolbar: true,
		report: {
			dataSource: {
				data: jsonData
			}
      ,"slice": {
        "rows": [
        {"uniqueName": "supplier","sort": "asc"}
        ,{"uniqueName": "itemid","sort": "asc"}
        ,{"uniqueName": "item","sort": "asc"}
        ],
        "columns": [
        {"uniqueName":"[Measures]"}
        ]
        ,"measures": [
          {"uniqueName":"salesorder","active": true, "caption":"Sales<br>Orders", "aggregation":"sum"}
          ,{"uniqueName":"available","active": true, "caption":"Available", "aggregation":"sum"}
          ,{"uniqueName":"leadtime","active": true}
        ]
      }
      ,"tableSizes": {
      	"columns": [{"tuple":[],"measure":"leadtime","width":60}]}
		}
	});