JSFiddle - React, Tailwind, and code Playground
by Ian Sadovy
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
.link {
text-decoration: underline !important;
cursor: pointer;
color: #726b04 !important;
}
JavaScript
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 430,
toolbar: true,
report: {
dataSource: {
data: getData()
},
slice: {
rows: [
{
uniqueName: "Category",
sort: "asc"
},
{
uniqueName: "Country",
sort: "unsorted"
},
{
uniqueName: "Discount",
sort: "unsorted"
},
{
uniqueName: "Quantity",
sort: "unsorted"
}
],
columns: [
{
uniqueName: "[Measures]"
}
],
measures: [
{
uniqueName: "Price",
aggregation: "sum"
}
],
flatOrder: [
"Category",
"Country",
"Price",
"Discount",
"Quantity"
]
},
options: {
grid: {
type: "flat"
}
},
conditions: [
{
formula: "#value = 0.0000012191",
measure: "Discount",
format: {
backgroundColor: "#FFF59D",
color: "#E53935",
fontFamily: "Arial",
fontSize: "12px"
}
}
]
}
});
function getData() {
return [{
"Category": "Accessories",
"Size": "262 oz",
"Color": "red",
"Destination": "Australia",
"Business Type": "Specialty Bike Shop",
"Country": "Australia",
"Price": 174,
"Quantity": 225,
"Discount": 0.0000012
}, {
"Category": "Accessories",
"Size": "214 oz",
"Color": "yellow",
"Destination": "Canada",
"Business Type": "Specialty Bike Shop",
"Country": "Canada",
"Price": 502,
"Quantity": 90,
"Discount": 0.0000012
}, {
"Category": "Components",
...