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) =>...