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 = [
	{
		"units" : 1,
    "rate": 1000,
    "total":1000,
		"unitOfMeasure" : "payment"
	},
	{
		"units" : 40,
    "rate": 30,
    "total":1200,
		"unitOfMeasure" : "hours"
	},	
  {
		"units" : 4,
    "rate": 60,
    "total":240,
		"unitOfMeasure" : "hours"
	}
	];

var pivot = new Flexmonster({
	container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
		toolbar: true,
		report: {
			dataSource: {
				data: jsonData
			},
			slice: {
				rows: [
						{ uniqueName: "rate" }
				],
				columns: [
						{ uniqueName: "[Measures]" }
				],
				measures: [
            {
              uniqueName: "units" 
            },
            {
                "uniqueName": "Formula #3",
                "formula": "if( sum(\"rate\")  == 30, sum(\"units\") , 0) ",
                "individual": true,
                "caption": "Formula #3"
            },
				]
			}
		}
	});