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>
<button onclick="getData()">
Get Data
</button>
<div id="pivot-container">The component will appear here</div>
JavaScript
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
"dataSource": {
"filename": 'data/data.csv'
},
"slice": {
"rows": [{
"uniqueName": "Color",
"filter": {
"members": [
"color.[blue]",
"color.[green]"
]
}
}],
"columns": [{
"uniqueName": "Category",
"filter": {
"members": [
"category.[accessories]",
"category.[components]"
]
}
},
{
"uniqueName": "[Measures]"
}
],
"measures": [{
"uniqueName": "Price",
"aggregation": "sum",
"active": true
}]
}
}
});
function getData() {
var measures = pivot.getMeasures();
var sliceWithOnlyMeasures = {
"reportFilters": [...pivot.getRows(), ...pivot.getColumns(), ...pivot.getReportFilters()],
"measures": measures
};
flexmonster.getData({
"slice": sliceWithOnlyMeasures
}, function(data) {
console.log(data)
})
}