Configure multilevel hierarchies

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>
<button onclick="setTableSizes()">Hide USA (and then try to expand/collapse)!</button>
<div id="pivot-container"></div>

CSS

h2 {
  text-align: center;
}

p {
  font-size: 15px;
  line-height: 1.5;
  padding-right: 10px;
  padding-left: 10px;
}

a {
  color: #00a45a;
  text-decoration: none;
}

a:hover {
  text-decoration: underline;
}

code {
    font-size: 105%;
    color: #DF3800;
    background-color: #f5f5f5;
    padding: 1px 4px;
    font-family: monospace !important;
    border-radius: 4px;
}

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  height: 400,
  report: {
    dataSource: {
      data: getData(),
      mapping: {
        "Country": {
          hierarchy: "Geography",
        },
        "State": {
          hierarchy: "Geography",
          parent: "Country"
        },
        "City": {
          hierarchy: "Geography",
          parent: "State"
        }
      }
    },
    slice: {
      columns: [{
          uniqueName: "[Measures]"
        },
        {
          uniqueName: "Color"
        }
      ],
      rows: [{
        uniqueName: "[Geography]"
      }],
      measures: [{
        uniqueName: "Price",
        aggregation: "sum"
      }]
    }
  }
});


function setTableSizes() {
  flexmonster.setTableSizes({
    "rows": [{
      "idx": 3,
      "height": 0
    }]
  });
}

function getData() {
  return [{
      "Color": "red",
      "Country": "Canada",
      "State": "Ontario",
      "City": "Toronto",
      "Price": 174
    },
    {
      "Color": "blue",
      "Country": "USA",
      "State": "California",
      "City": "Los Angeles",
      "Price": 166
    }
  ];
}