JSFiddle - React, Tailwind, and code Playground
Data source
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/",
width: "100%",
height: 500,
toolbar: true,
reportcomplete: expandData,
report: {
dataSource: {
type: "api",
url: "https://olap.flexmonster.com:9500",
index: "fm-product-sales",
},
slice: {
rows: [
{
uniqueName: "Color",
},
{
uniqueName: "Country",
},
{
uniqueName: "[Measures]",
},
],
columns: [],
measures: [
{
uniqueName: "Price",
},
],
},
},
})
function expandData() {
pivot.getMembers("Color", "", onGetMembers)
function onGetMembers(members) {
for (var i = 0; i < members.length; i++) {
pivot.expandCell("rows", [`color.[${members[i].uniqueName}]`])
}
}
}