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 = [{
'claimObject.date_mission.y': {
type: 'level',
caption: 'Year',
hierarchy: 'Mission Date',
level: 'Year'
},
'claimObject.date_mission.m': {
type: 'level',
caption: 'Month',
hierarchy: 'Mission Date',
level: 'Month',
parent: 'Year'
},
'claimObject.date_mission.w': {
type: 'level',
caption: 'Week',
hierarchy: 'Mission Date',
level: 'Week',
parent: 'Month'
},
'value': {
type: 'number'
}
}, {
"claimObject.date_mission.y": "2017",
"claimObject.date_mission.m": "Jan",
"claimObject.date_mission.w": "Week 1",
"value": 10
}, {
"claimObject.date_mission.y": "2017",
"claimObject.date_mission.m": "Feb",
"claimObject.date_mission.w": "Week 2",
"value": 10
}, {
"claimObject.date_mission.y": "2017",
"claimObject.date_mission.m": "Mar",
"claimObject.date_mission.w": "Week 3",
"value": 10
}];
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
data: jsonData
},
"slice": {
"columns": [{
"uniqueName": "Mission Date",
"levelName": "Month",
}, {
"uniqueName": "[Measures]"
}],
"measures": [{
"uniqueName": "value",
"aggregation": "sum"
}],
"drills": {
"columns": [{
"tuple": [
"year.[2017]"
]
}, {
"tuple": [
"year.[2017].[jan]"
]
}]
}
}
}
});