Slice defined with rows, columns and measures

Slice configuration

by Viacheslav Mukha

HTML

<link rel="stylesheet" href="https://cdn.flexmonster.com/2.3/demo.css">
<script src="https://cdn.flexmonster.com/2.9.45/flexmonster.js"></script>
<div id="pivot-container"></div>

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    "options": {
      "grid": {
        "showFilter": false,
        "type": "flat",
        "showGrandTotals": "off"
      },
      "editing": true
    },
    "dataSource": {
      "data": [
        {
          "marketCode": "Retail",
          "marketSegment": "Retail",
          "marketCategory": "Retail"
        },
        {
          "marketCode": "Qualified Discount",
          "marketSegment": "Qualified Discount",
          "marketCategory": "Qualified Discount"
        },
        {
			    "marketCode": "Wholesale",
    			"marketSegment": "Wholesale",
    		  "marketCategory": "Wholesale"
  		  },
        {
          "marketCode": "UNKNOWN",
          "marketSegment": "UNKNOWN",
          "marketCategory": "UNKNOWN"
        }
      ],
      "dataSourceType": "json"
    },
    "slice": {
      "columns": [
        {
          "uniqueName": "marketCode"
        },
        {
          "uniqueName": "marketSegment"
        },
        {
          "uniqueName": "marketCategory"
        }
      ]
    },
    "conditions": [],
    "formats": [],
  }
});