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: {
grid: {
type: "classic"
}
},
dataSource: {
filename: "data/data.csv"
},
slice: {
rows: [{
uniqueName: "Category"
},
{
uniqueName: "Country"
},
],
columns: [{
uniqueName: "Business Type"
}, {
uniqueName: "[Measures]"
}],
measures: [{
uniqueName: "Price",
aggregation: "sum"
},
{
uniqueName: "Discount",
aggregation: "sum"
},
{
uniqueName: "Calculated field",
formula: "sum('Price')+sum('Discount')",
caption: "Sum(Price+Discount)"
}
]
},
conditions: [
{
formula: "#value > 0",
measure: "Calculated field",
format: {
backgroundColor: "#8BC34A"
}
}
],
}
});