Data types in JSON

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 = [
        {
            "Color" : "green",
            "Country" : "Canada",
            "State" : "Ontario",
            "City" : "Toronto",
            "Price" : 174,
            "Quantity" : 22
        },
        {
            "Color" : "red",
            "Country" : "USA",
            "Price" : 166,
            "Quantity" : 19
        }
    ];

var pivot = new Flexmonster({
	container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  report: {
  	localization: {"grid": {"blankMember": "Custom text"}},
    dataSource: {
      data: jsonData
    },
		slice: {
			rows: [
				{ uniqueName: "Country" },
				{ uniqueName: "State" },
        { uniqueName: "City" }
			],
			columns: [
				{ uniqueName: "[Measures]" }
			],
			measures: [
				{ uniqueName: "Price", aggregation: "sum" }
			]
		}
  }
});