Hide or show field captions on the grid

Options

by Flexmonster Pivot Table

HTML

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

<button onclick="setCaptions(true)">Show field caption</button>
<button onclick="setCaptions(false)">Hide field caption</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.csv",
    },
    slice: {
      rows: [
        {
          uniqueName: "Category",
        },
      ],
      columns: [
        {
          uniqueName: "Business Type",
        },
        {
          uniqueName: "Color",
        },
        {
          uniqueName: "[Measures]",
        },
      ],
      measures: [
        {
          uniqueName: "Price",
          aggregation: "sum",
        },
      ],
      expands: {
        columns: [
          {
            tuple: ["business type.[specialty bike shop]"],
          },
        ],
      },
    },
    options: {
      grid: {
        showHierarchyCaptions: false,
      },
    },
  },
});

function setCaptions(value) {
  var options = pivot.getOptions();
  options.grid.showHierarchyCaptions = value;
  pivot.setOptions(options);
  pivot.refresh();
}