Configure multilevel hierarchies - example with the custom data source API
Data source
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>
JavaScript
let pivot = new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 550,
toolbar: true,
report: {
dataSource: {
type: "api",
url: "https://olap.flexmonster.com:9500",
index: "fm-product-sales",
},
options: {
showEmptyData: false
},
slice: {
reportFilters: [{
uniqueName: "Color",
filter: {
members: ["green"]
}
}, {
uniqueName: "Destination",
filter: {
members: ["Australia"]
}
}, {
uniqueName: "Country",
filter: {
members: ["Germany"]
}
}],
rows: [{
uniqueName: "Category"
}],
columns: [{
uniqueName: "[Measures]"
}],
measures: [{
uniqueName: "Price",
aggregation: "sum"
}]
}
}
});