Flexmonster - Pivot Table demo

Demos

by Dongor7

HTML

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

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

CSS

.fm-custom-cell {
  display: flex !important;
  align-items: center !important;
  font-size: 12px !important;
}

.fm-custom-cell .flag-icon {
  width: 21px !important;
  height: 16px !important;
  margin-left: 0 !important;
  margin-right: 2px !important;
}

#fm-pivot-view .fm-grid-layout .fm-custom-cell.fm-expanded .fm-expanded-icon::before, 
#fm-pivot-view .fm-grid-layout .fm-custom-cell.fm-collapsed .fm-collapsed-icon::before {
  top: -2px;
  height: 16px;
}

JavaScript

new Flexmonster({
  container: "#pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  height: 150,
  toolbar: true,
  report: {
    dataSource: {
      type: "json",
      filename: "data/retail-data.json",
      mapping: {
        "Quantity": {
          type: "number",
        },
        "Price": {
          type: "number",
        },
        "Retail Category": {
          type: "string",
        },
        "Sales": {
          type: "number",
        },
        "Order Date": {
          type: "year/quarter/month/day",
        },
        "Date": {
          type: "date",
        },
        "Status": {
          type: "string",
        },
        "Product Code": {
          type: "string",
        },
        "Phone": {
          type: "string",
        },
        "Country": {
          type: "string",
          folder: "Location",
        },
        "City": {
          type: "string",
          folder: "Location",
        },
        "CurrencyID": {
          type: "property",
          hierarchy: "Country",
        },
        "Contact Last Name": {
          type: "string",
        },
        "Contact First Name": {
          type: "string",
        },
        "Deal Size": {
          type: "string",
        },
      },
    },
    slice: {
      rows: [
        {
          uniqueName: "Country",
          filter: {
            members: [
              "country.[australia]",
              "country.[usa]",
              "country.[japan]",
            ],
          },
        },
        {
          uniqueName: "Status",
        },
      ],
      columns: [
        {
          uniqueName: "Order Date",
        },
        {
          uniqueName: "[Measures]",
        },
      ],
      measures: [
        {
          uniqueName: "Price",
          aggregation: "sum",
          format: "-13w0a1w1c23j00",
        },
      ],
      sorting: {
        column: {
          type: "desc",
          tuple: [],
          measure: {
            uniqueName:...