Expand restoration

Slice configuration

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>
<button id="print-report">
   Print
</button>
<button id="get-and-load">
   Get & Load report
</button>

JavaScript

var jsondata = [{
  "Color": "green",
  "M": "September",
  "W": "Wed",
  "111": "Canada",
  "state": "Ontario",
  "city": "Toronto",
  "Price": 174,
  "Quantity": 22
}, {
  "Color": "red",
  "M": "March",
  "W": "Mon",
  "Time": "1000",
  "111": "USA",
  "state": "California",
  "city": "Los Angeles",
  "Price": null,
  "Quantity": 19
}];

var pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  width: "100%",
  height: 430,
  toolbar: true,
  report: {
    dataSource: {
      data: jsondata
    },
    slice: {
      rows: [{
        caption: "Country",
        uniqueName: "111"
      }, {
        uniqueName: "Color"
      }],
      columns: [{
        uniqueName: "[Measures]"
      }],
      measures: [{
        uniqueName: "Price"
      }, {
        uniqueName: "Quantity"
      }],
      expands: {
        rows: [{
          "tuple": ["111.[canada]"]
        }]
      }
    },
    formats: [{
      name: "",
      thousandsSeparator: ",",
      decimalSeparator: ".",
      decimalPlaces: 0,
      nullValue: "",
      infinityValue: "Over",
      divideByZeroValue: "DIV/0"
    }]
  }
});


document.getElementById('print-report').addEventListener('click', () => {
  console.log('config', pivot.getReport());
});

document.getElementById('get-and-load').addEventListener('click', () => {
  pivot.setReport(pivot.getReport());
});