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
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
mapping: {
"Color": {
caption: "color"
},
"Country": {
caption: "MyCountry",
dimensionCaption: "Place",
dimensionUniqueName: "Place"
},
"State": {
caption: "MyState",
dimensionCaption: "Place",
dimensionUniqueName: "Place"
},
"City": {
caption: "MyCity",
dimensionCaption: "Place",
dimensionUniqueName: "Place"
},
"Price": {
type: "number",
caption: "MyPrice"
},
"Quantity": {
type: "number",
caption: "MyQuantity"
}
},
data: [{
"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
}
]
},
slice: {
rows: [{
"uniqueName": "City"
}],
columns: [{
"uniqueName": "[Measures]"
}],
measures: [{
"uniqueName": "Price",
"aggregation": "sum"
},
{
"uniqueName": "Quantity",
"aggregation": "sum"
}
]
}
}
});