JSFiddle - React, Tailwind, and code Playground
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 = [{
"ColumnA": "2015-01-01T00:00:00Z",
"ColumnB": "XYZ",
"ColumnC": "1234",
"ColumnD": "AB",
"Measure": 332
},
{
"ColumnA": "2015-01-01T00:00:00Z",
"ColumnB": "XYZ",
"ColumnC": "1234",
"ColumnD": "AB",
"Measure": 45636
},
{
"ColumnA": "2015-01-01T00:00:00Z",
"ColumnB": "XYZ",
"ColumnC": "1234",
"ColumnD": "AB",
"Measure": 1324
},
{
"ColumnA": "2015-01-01T00:00:00Z",
"ColumnB": "XYZ",
"ColumnC": "1234",
"ColumnD": "AB",
"Measure": 45
},
{
"ColumnA": "2015-01-01T00:00:00Z",
"ColumnB": "XYZ",
"ColumnC": "1234",
"ColumnD": "AB",
"Measure": 897
}
];
let dataCaptions = {
"ColumnA": {
caption: "Column A"
},
"ColumnB": {
caption: "Column B"
},
"ColumnC": {
caption: "Column C"
},
"ColumnD": {
caption: "Column D"
},
"Measure": {
caption: "Measure",
type: "number"
},
"ColumnF": {
caption: "Column F"
}
}
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
data: jsonData,
mapping: dataCaptions
},
slice: {
rows: [{
uniqueName: "ColumnA"
},
{
uniqueName: "ColumnB"
},
{
uniqueName: "ColumnC"
},
{
uniqueName: "ColumnD"
}
],
measures: [{
uniqueName: "Measure",
aggregation: "sum"
}],
expands: {
expandAll: true
}
},
options: {
grid: {
type: "flat"
}
}
}
});