JSFiddle - React, Tailwind, and code Playground
Slice configuration
by Flexmonster Pivot Table
HTML
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<div id="filtersArea">
<label for="filter">Business type:</label>
<select name="filter" id="filter" onchange="setFilter"></select>
</div>
<div class="pivot-wrapper">
<div id="pivot-container1"></div>
<div id="pivot-container2"></div>
</div>
CSS
#filtersArea {
padding: 5px 7px;
border: 1px solid #e5e5e5;
}
.pivot-wrapper {
display: flex;
}
JavaScript
let pivot1 = new Flexmonster({
container: "pivot-container1",
componentFolder: "https://cdn.flexmonster.com/",
report: {
dataSource: {
type: "api",
url: "https://olap.flexmonster.com:9500",
index: "fm-product-sales",
},
options: {
grid: {
showFilter: false,
},
},
slice: {
reportFilters: [
{
uniqueName: "Business Type",
filter: {
members: ["business type.[specialty bike shop]"],
},
},
],
rows: [
{
uniqueName: "Country",
},
{
uniqueName: "Category",
},
{
uniqueName: "Color",
},
],
columns: [
{
uniqueName: "[Measures]",
},
],
measures: [
{
uniqueName: "Price",
aggregation: "sum",
},
],
expands: {
expandAll: true,
},
},
},
reportcomplete: () => {
showFilters("Business Type")
},
})
let pivot2 = new Flexmonster({
container: "pivot-container2",
componentFolder: "https://cdn.flexmonster.com/",
report: {
dataSource: {
type: "api",
url: "https://olap.flexmonster.com:9500",
index: "fm-product-sales",
},
options: {
grid: {
showFilter: false,
},
},
slice: {
reportFilters: [
{
uniqueName: "Business Type",
filter: {
members: ["business type.[specialty bike shop]"],
},
},
],
rows: [
{
uniqueName: "Destination",
},
{
uniqueName: "Country",
},
{
uniqueName: "Color",
},
],
columns: [
{
uniqueName: "[Measures]",
},
],
measures: [
{
uniqueName: "Quantity",
...