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://code.jquery.com/jquery-2.2.4.min.js"></script>
<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/",
width: "100%",
height: 430,
toolbar: true,
report: {
dataSource: {
filename: "data/data.csv"
},
options: {
grid: {
type: "flat"
}
},
slice: {
rows: [{
uniqueName: "Color"
}, {
uniqueName: "Country"
}],
columns: [{
uniqueName: "[Measures]"
}],
measures: [{
uniqueName: "Price",
format: "currency"
}],
}
}
});
flexmonster.customizeContextMenu(function(items, data, viewType) {
if (data.hierarchy && data.hierarchy.uniqueName == "Price")
items.push({
label: "Set as 1st",
handler: function() {
var report = pivot.getReport();
report.slice.flatOrder = ["Price"];
pivot.setReport(report);
}
});
items.push({
label: "Set back",
handler: function() {
var report = pivot.getReport();
report.slice.flatOrder = [];
pivot.setReport(report);
}
});
return items;
});