Expand or collapse a specific node on the grid

Configuring the slice

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

<button onclick="expandCell('rows', ['Accessories','Canada'])">Expand Canada</button>
<button onclick="collapseCell('rows', ['Accessories','Canada'])">Collapse Canada</button>

<div id="pivot-container"></div>

CSS

@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    dataSource: {
      filename: "data/data.json"
    },
    slice: {
      rows: [
      			{
                uniqueName: "Category"
            },
            {
                uniqueName: "Country",
                filter: {
                	members: ["Canada", "France", "Germany"]
                }
            },
            {
                uniqueName: "Color"
            }
        ],
        columns: [
            {
                uniqueName: "[Measures]"
            }
        ],
        measures: [
            {
                uniqueName: "Price"
            }
        ],
        expands: {
        	rows: [
          	{
            	tuple: ["category.[accessories]"]
            }
          ]
        }
    }
  }
});

function expandCell(axis, tuple) {
	pivot.expandCell(axis, tuple);
}

function collapseCell(axis, tuple) {
	pivot.collapseCell(axis, tuple);
}