JSFiddle - React, Tailwind, and code Playground

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<button onclick="setData(getData1())"> setData1</button>
<button onclick="setData(getData2())"> setData2</button>

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

JavaScript

var pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    dataSource: {
      data: getData1()
    },
    slice: {
      measures: [{
        uniqueName: "Price",
        aggregation: "sum"
      }],
      rows: [{
        filter: {
          members: ["color.[red]"]
        },
        uniqueName: "Color"
      }],
      columns: [{
        filter: {
          members: ["city.[los angeles]"]
        },
        uniqueName: "City"
      }]
    }
  }
});


function setData(data) {
  let prevFilters = getFilters();
  let report = pivot.getReport();
  
  report.dataSource.data = data;
  pivot.setReport(report);
  
  pivot.on('reportcomplete', function() {
    pivot.off("reportcomplete");
    let currFilters = getFilters();
    checkFilters(prevFilters, currFilters);
  });
}

function checkFilters(prevFilters, currFilters) {
  let missingFilters = [];
  for (let filter of prevFilters) {
    if (!currFilters.includes(filter)) {
      missingFilters.push(filter);
    }
  }

  if (missingFilters.length > 0) {
    let extractedValues = missingFilters.map(filter => {
      let key = Object.keys(filter)[0];
      let value = filter[key][0];
      let match = value.match(/(.+?)\./);
      return match ? match[1] : null;
    });
    handleEmptyData(extractedValues.join(", "))
  }
}

function getFilters() {
  let fields = pivot.getAllHierarchies();
  let filters = [];
  for (let f of fields)
    if (pivot.getFilter(f.uniqueName))
      filters.push(pivot.getFilter(f.uniqueName));
  return filters;
}

function handleEmptyData(filters) {
  pivot.alert({
    title: "No data found for filters " + filters,
    message: "No data is available for the selected filters. Showing all data.",
    type: "info",
    blocking: false
  });
}


function getData1() {
  return [{
      "Color": "green",
      "Country": "Canada",
      "State": "Ontario",
      "City": "Toronto",
      "Price": 174,
     ...