Using defaultDateType to specify the default date type

Options

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

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

CSS

@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  global: {
    options: {
      "defaultDateType": "date string",
      "datePattern": "dd/MM/yyyy"
    }
  },
  report: {
    dataSource: {
      data: getData()
    },
    options: {
    	grid: {
      	type: "flat"
      }
    }
  }
});

function getData() {
  return [{
      "Date": "2021-03-04",
      "Event": "Concert",
      "Price": 56
    },
    {
      "Date": "2020-01-11",
      "Event": "Performance",
      "Price": 34
    },
    {
      "Date": "2021-03-08",
      "Event": "Cinema",
      "Price": 10
    }
  ]
}