Pivot breaking with classic mode and show grand totals for rows only
by FaTor
HTML
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<div id="pivot-container"></div>
JavaScript
const pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 800,
toolbar: true,
report: {
dataSource: {
type: "api",
url: "https://olap.flexmonster.com:9500",
index: "fm-product-sales",
},
options: {
grid: {
type: "classic",
showGrandTotals: "rows",
},
},
slice: {
expands: {
expandAll: true
},
rows: [
{
uniqueName: "Category",
},
{
uniqueName: "Color",
},
{
uniqueName: "[Measures]",
},
],
columns: [],
measures: [
{
uniqueName: "Price",
},
{
uniqueName: "Quantity",
},
],
},
},
})