JSON array of arrays
Data source
HTML
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<div id="pivot-container"></div>
JavaScript
var inlineJSON = [
{
0: {
"type": "string",
caption: "category",
uniqueName: "category"
},
1: {
"type": "string",
caption: "5",
uniqueName: "5"
},
2: {
"type": "number",
caption: "Price",
uniqueName: "Price"
},
3: {
"type": "number",
caption: "1",
uniqueName: "1"
}
},
[
"Ice-cream",
"red",
23.32,
4
],[
"Ice-cream",
"red",
10000000,
4
],
];
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
data: inlineJSON
},
options: {
grid: {
type: 'flat'
}
}
/* slice: {
rows: [
{ uniqueName: "Category" }
],
columns: [
{ uniqueName: "Color" },
{ uniqueName: "[Measures]" }
],
measures: [
{ uniqueName: "Price" }
]
} */
}
});