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/2.4/flexmonster.js"></script>
<div id="pivot-container"></div>
JavaScript
new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/2.4/",
width: "100%",
height: 600,
toolbar: true,
report: {
"dataSource": {
"dataSourceType": "microsoft analysis services",
"proxyUrl": "https://olap.flexmonster.com/olap/msmdpump.dll",
"catalog": "Adventure Works DW Standard Edition",
"cube": "Adventure Works"
},
"slice": {
"rows": [
{
"uniqueName": "[Product].[Category]"
},
{
"uniqueName": "[Employee].[Gender]"
}
],
"columns": [
{
"uniqueName": "[Sales Reason].[Sales Reason]",
"filter": {
"members": [
"[Sales Reason].[Sales Reason].&[8]",
"[Sales Reason].[Sales Reason].&[4]",
"[Sales Reason].[Sales Reason].&[6]",
"[Sales Reason].[Sales Reason].&[5]"
]
}
},
{
"uniqueName": "[Measures]"
}
],
"measures": [
{
"uniqueName": "[Measures].[Reseller Order Count]"
}
],
"expands": {
"rows": [
{
"tuple": [
"[Product].[Category].&[4]"
]
}
]
}
},
"options": {
"grid": {
"showHierarchies": false,
"showMeasures": false,
"showAllLabels": true,
"multipleMeasures": true,
"showFilter": false,
"showReportFiltersArea": false,
"showHierarchyCaptions": false
}
}
}
});