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>
<div id="pivot-container"></div>
CSS
.fm-custom-cell {
display: flex !important;
align-items: center !important;
font-size: 12px !important;
}
.fm-custom-cell .flag-icon {
width: 21px !important;
height: 16px !important;
margin-left: 0 !important;
margin-right: 2px !important;
}
#fm-pivot-view .fm-grid-layout .fm-custom-cell.fm-expanded .fm-expanded-icon::before,
#fm-pivot-view .fm-grid-layout .fm-custom-cell.fm-collapsed .fm-collapsed-icon::before {
top: -2px;
height: 16px;
}
JavaScript
new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
height: 550,
toolbar: true,
report: {
dataSource: {
type: "json",
filename: "data/retail-data.json",
mapping: {
"Order Date": {
type: "year/quarter/month/day",
},
"Date": {
type: "date",
}
}
},
slice: {
rows: [
{
uniqueName: "Status",
},
],
columns: [{
uniqueName: "Order Date",
},
{
uniqueName: "[Measures]",
},
],
measures: [{
uniqueName: "Price",
aggregation: "sum",
format: "-13w0a1w1c23j00",
}, ],
sorting: {
column: {
type: "desc",
tuple: [],
measure: {
uniqueName: "Price",
aggregation: "sum",
},
},
},
expands: {
rows: [{
tuple: ["country.[japan]"],
}, ],
},
drills: {
columns: [{
tuple: ["order date.[2019]"],
}, ],
}
},
formats: [{
name: "-13w0a1w1c23j00",
thousandsSeparator: " ",
decimalSeparator: ".",
decimalPlaces: 0,
currencySymbol: "$",
positiveCurrencyFormat: "$1",
nullValue: "-",
textAlign: "right",
isPercent: false,
}, ],
options: {
viewType: "charts",
chart: {
type: "stacked_column"
}
}
}
});