JSFiddle - React, Tailwind, and code Playground

Demos

by Flexmonster Pivot Table

HTML

<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

<select id="countryDropdown" onchange="changeSubquery(this.value)">
  <option value="Australia">Australia</option>
  <option value="Canada">Canada</option>
  <option value="France">France</option>
  <option value="Germany">Germany</option>
  <option value="United Kingdom">United Kingdom</option>
  <option value="United States">United States</option>
</select>

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

JavaScript

let pivot = new Flexmonster({
  container: "#pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  height: 600,
  toolbar: true,
  report: {
    dataSource: {
      type: "microsoft analysis services",
      proxyUrl: "https://olap.flexmonster.com:8085/",
      catalog: "Adventure Works DW Standard Edition",
      cube: "Adventure Works",
      binary: true,
      subquery:
        "select {[Customer].[Customer Geography].[Country].&[Australia]} on columns from [Adventure Works]",
    },

    slice: {
      columns: [
        {
          uniqueName: "[Measures]",
        },
      ],
      measures: [
        {
          uniqueName: "[Measures].[Internet Total Product Cost]",
        },
      ],
      rows: [
        {
          uniqueName: "[Customer].[Customer]",
        },
      ],
    },
    options: {
      showMemberProperties: true,
    },
  },
})

function changeSubquery(countryName) {
  let report = pivot.getReport();
  report.dataSource.subquery = `select {[Customer].[Customer Geography].[Country].&[${countryName}]} on columns from [Adventure Works]`;
  pivot.setReport(report);
}