JSFiddle - React, Tailwind, and code Playground

Slice configuration

by Flexmonster Pivot Table

HTML

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

<div class="filter-bar">
  <label for="product-filter">Filter products:</label>
  <select id="product-filter" disabled></select>
</div>

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

CSS

@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);
.filter-bar {
  margin-bottom: 10px;
  font-family: Arial, sans-serif;
  font-size: 14px;
}
.filter-bar select {
  margin-left: 6px;
  padding: 4px;
  font-size: 14px;
}

JavaScript

const productFilters = {
  'Sold > 1000 AND Margin < 200': (sold, margin) => sold > 1000 && margin < 200,
  'Sold < 500 OR Sold > 2000': (sold, margin) => sold < 500 || sold > 2000,
  'Sold < 500 OR Margin > 2000': (sold, margin) => sold < 500 || margin > 2000,
};

const filterSelect = document.getElementById('product-filter');
filterSelect.add(new Option('All products', ''));
Object.keys(productFilters).forEach((name) =>
  filterSelect.add(new Option(name, name)),
);
filterSelect.value = 'Sold > 1000 AND Margin < 200';
filterSelect.addEventListener('change', () =>
  applyProductFilter(filterSelect.value),
);

let pivot = new Flexmonster({
  container: 'pivot-container',
  componentFolder: 'https://cdn.flexmonster.com/',
  licenseFilePath: 'https://cdn.flexmonster.com/jsfiddle.charts.key',
  toolbar: true,
  report: {
    dataSource: {
      type: 'json',
      data: getData(),
    },
    slice: {
      rows: [
        {
          uniqueName: 'Product',
        },
      ],
      columns: [
        {
          uniqueName: '[Measures]',
        },
      ],
      measures: [
        {
          uniqueName: 'Sold',
          aggregation: 'sum',
        },
        {
          uniqueName: 'Margin',
          aggregation: 'sum',
        },
      ],
    },
  },
  reportcomplete: function () {
    pivot.off('reportcomplete');
    filterSelect.disabled = false;
    applyProductFilter(filterSelect.value);
  },
});

function applyProductFilter(filterName) {
  if (!filterName) {
    pivot.clearFilter('Product');
    return;
  }
  const matches = productFilters[filterName];

  pivot.getData(
    {
      slice: {
        rows: [{ uniqueName: 'Product' }],
        columns: [{ uniqueName: '[Measures]' }],
        measures: [
          { uniqueName: 'Sold', aggregation: 'sum' }, // v0
          { uniqueName: 'Margin', aggregation: 'sum' }, // v1
        ],
      },
    },
    (rawData) =>...