JSFiddle - React, Tailwind, and code Playground
by Flexmonster Pivot Table
HTML
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<div id="pivot-container"></div>
JavaScript
let pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
options: {
configuratorActive: true
},
dataSource: {
mapping: {
"Country": {
folder: "Place"
},
"State": {
folder: "Place"
},
"City": {
folder: "Place"
},
"Price": {
type: "number",
},
"Quantity": {
type: "number",
}
},
data: getData()
},
slice: {
rows: [{
"uniqueName": "Country"
}, {
"uniqueName": "City"
}],
columns: [{
"uniqueName": "[Measures]"
}],
measures: [{
"uniqueName": "Price",
"aggregation": "sum"
},
{
"uniqueName": "Quantity",
"aggregation": "sum"
}
]
}
}
});
function getData() {
return [{
"Color": "green",
"Country": "Canada",
"State": "Ontario",
"City": "Toronto",
"Price": 174,
"Quantity": 22
},
{
"Color": "red",
"Country": "USA",
"State": "California",
"City": "Los Angeles",
"Price": 166,
"Quantity": 19
}
]
}