Flexmonster - Pivot Table demo

Demos

by sergin

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/",
  width: "100%",
  height: 550,
        customizeCell: customizeCell,
        shareReportConnection: {
            url: "https://olap.flexmonster.com:9500"
        },
        beforetoolbarcreated: function (toolbar) {
            toolbar.showShareReportTab = true;
            toolbar.shareReportHandler = function () {
                toolbar.pivot.shareReport({
                    url: "https://olap.flexmonster.com:9500"
                })
            }
        },
        toolbar: true,
        report: {
            "dataSource": {
                "type": "json",
                "filename": "https://cdn.flexmonster.com/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": {
  ...