Pivoting loses cell values
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: 850,
toolbar: true,
report: {
"dataSource": {
"type": "api",
"url": "https://olap.flexmonster.com:9500",
"index": "fm-product-sales",
"mapping": {
"Category": {
"type": "string",
"hierarchy": "Tree1"
},
"Color": {
"type": "string",
"hierarchy": "Tree1",
"parent": "Category"
},
"Size": {
"type": "string",
"hierarchy": "Tree1",
"parent": "Color"
},
"Country": {
"type": "string",
"hierarchy": "Tree2"
},
"Destination": {
"type": "string",
"hierarchy": "Tree2",
"parent": "Country"
},
}
},
"slice": {
columns: [{
uniqueName: "Tree2"
}],
drills: {
columns: [{
tuple: ["Tree2.[Australia]"]
}, {
tuple: ["Tree2.[Canada]"]
}, {
tuple: ["Tree2.[France]"]
}, {
tuple: ["Tree2.[Germany]"]
}, {
tuple: ["Tree2.[United Kingdom]"]
}, {
tuple: ["Tree2.[United States]"]
}],
rows: [{
tuple: ["Tree1.[Accessories]"]
}, {
tuple: ["Tree1.[Bikes]"]
}, {
tuple: ["Tree1.[Clothing]"]
}, {
tuple: ["Tree1.[Components]"]
}, {
tuple: ["Tree1.[Cars]"]
}, {
tuple: ["Tree1.[Accessories].[green]"]
}]
},
measures: [{
aggregation: "sum",
grandTotalCaption: "Price",
uniqueName: "Price"
}, {
aggregation: "sum",
grandTotalCaption: "Quantity",
uniqueName: "Quantity"
}],
rows: [{
uniqueName: "Tree1"
}, {
uniqueName: "[Measures]"
}]
}/*,
options: {
grid: {
showHeaders: false,
showGrandTotals: "off",
showHierarchies: false,
showHierarchyCaptions: true,
...