JSFiddle - React, Tailwind, and code Playground

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>
<div style='width: 2000px;'>
  <div id="pivot-container"></div>
</div>

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  height: 600,
  Width: "100%",
  report: {
    dataSource: {
      filename: "data/retail-data.json",
    },
    options: {
      grid: {
        type: "classic"
      }
    },
    slice: {
      rows: [{
          uniqueName: "Retail Category"
        },
        {
          uniqueName: "Country"
        },
        {
          uniqueName: "City"
        },
        {
          uniqueName: "Date.Year"
        },
        {
          uniqueName: "Date.Month"
        },
        {
          uniqueName: "Date.Day"
        },
      ],
      columns: [{
        uniqueName: "Status"
      }, {
        uniqueName: "[Measures]"
      }],
      measures: [{
        uniqueName: "Price",
        aggregation: "sum"
      }],
      "expands": {
        "rows": [{
            "tuple": [
              "retail category.[arts, crafts & sewing]"
            ]
          },
          {
            "tuple": [
              "retail category.[arts, crafts & sewing]",
              "country.[australia]"
            ]
          },
          {
            "tuple": [
              "retail category.[arts, crafts & sewing]",
              "country.[australia]",
              "city.[canberra]"
            ]
          },
          {
            "tuple": [
              "retail category.[arts, crafts & sewing]",
              "country.[australia]",
              "city.[canberra]",
              "date.year.[2019]"
            ]
          },
          {
            "tuple": [
              "retail category.[arts, crafts & sewing]",
              "country.[australia]",
              "city.[canberra]",
              "date.year.[2019]",
              "date.month.[may]"
            ]
          }
        ]
      }
    }
  }
});