Flexmonster - Pivot Table demo

Demos

by Sundarapandiyan_pa

HTML

<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.15/lodash.min.js"></script>
<button onclick="formatHeatMap()">Format HeatMap</button>
<div id="pivot-container"></div>

JavaScript

var pivot = new Flexmonster({
  container: "#pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  width: "100%",
  height: 430,
  toolbar: true,
  customizeCell: customizeCellFunction,
  report: {"dataSource":{"type":"json","data":[{"State":{"type":"string"},"Net Sales ($)":{"type":"number"},"Check Count":{"type":"number"},"Gross Sales ($)":{"type":"number"}},{"State":"NY","Net Sales ($)":13293.61,"Check Count":572,"Gross Sales ($)":13765.91},{"State":"MA","Net Sales ($)":50669.7099999999,"Check Count":2756,"Gross Sales ($)":53370.2299999999},{"State":"OR","Net Sales ($)":84457.8499999998,"Check Count":4693,"Gross Sales ($)":89343.5299999999},{"State":"IL","Net Sales ($)":98479.89,"Check Count":5883,"Gross Sales ($)":103852.88},{"State":"WA","Net Sales ($)":178076.630000001,"Check Count":10026,"Gross Sales ($)":185192.830000001},{"State":"CA","Net Sales ($)":1344346.43999994,"Check Count":72342,"Gross Sales ($)":1435108.07999997}]},"slice":{"rows":[{"uniqueName":"State","sort":"unsorted"}],"columns":[{"uniqueName":"[Measures]"}],"measures":[{"uniqueName":"Net Sales ($)","aggregation":"sum","grandTotalCaption":"Net Sales ($)","format":"net_sales"},{"uniqueName":"Gross Sales ($)","aggregation":"sum","grandTotalCaption":"Gross Sales ($)","format":"gross_sales"},{"uniqueName":"Check Count","aggregation":"sum","grandTotalCaption":"Check Count","format":"check_count"},{"uniqueName":"State","aggregation":"count","grandTotalCaption":"State","active":false,"availableAggregations":["count","distinctcount"]}],"expands":{"expandAll":true}},"options":{"grid":{"type":"flat","showHeaders":false,"showTotals":"off"},"chart":{"axisShortNumberFormat":true},"configuratorButton":false,"datePattern":"MMM d,...