JSON data source

Data source

by ilaria_nunziante

HTML

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

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

JavaScript

var jsonData = [
	{
		"Product" : "Product1",
		"Customer" : "Customer1",
    "Bucket": "Gen",
		"Forecast" : 100,
		"Sales" : 450
	},
	{
		"Product" : "Product1",
		"Customer" : "Customer1",
    "Bucket": "Feb"
	},
	{
		"Product" : "Product1",
		"Customer" : "Customer1",
    "Bucket": "Mar"
	},
	{
		"Product" : "Product2",
		"Customer" : "Customer2",
    "Bucket": "Gen"
	},
	{
		"Product" : "Product2",
		"Customer" : "Customer2",
    "Bucket": "Gen",
		"Sales" : 450
	},
	];

var pivot = new Flexmonster({
	container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
		toolbar: true,
		report: {
			dataSource: {
				data: jsonData
			},
    options: {
      grid: {
        type: "classic",
        showEmptyValues: true
      }
    },
			slice: {
				rows: [
				{ uniqueName: "Product" },
				{ uniqueName: "[Measures]" }
				],
				columns: [
				{ uniqueName: "Customer" },
				{ uniqueName: "Bucket" }
				],
				measures: [
				{
					uniqueName: "Forecast", 
					aggregation: "sum" 
				},
				{
					uniqueName: "Sales", 
					aggregation: "sum" 
				}
				]
			}
		}
	});
  
  
  flexmonster.getMembers('Bucket', '', 'onGetMembers');
  onGetMembers = function(members){
  	debugger;
  }