customFields property to set custom fields when exporting to Excel

Export and print

by jesperra

HTML

<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<button id="btn" onclick="onExport()">Export to ecxel</button>
<div id="pivot-container"></div>

JavaScript

var pivot = new Flexmonster({
	container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  width: "100%",
  height: 430,
  report: {
  	"customFields": 
    	[{
      	"name":"Field1",
        "value":"Value1"
       },
       {
       	"name":"Field2",
        "value":"Value2"
       }
     	],
    dataSource: {
      data: getData()
    },
    slice: {
      rows: [{uniqueName: "Color"}, {uniqueName: "Country"}],
      columns: [{uniqueName: "[Measures]"}],
      measures: [{uniqueName: "Price"}]
    }
  }
  
});

function onExport() {
	flexmonster.exportTo("excel",{
  	excelSheetName: "Pivot Table"
  });  
}

function getData() {
  return [{
    "Color": "green",
    "M": "September",
    "W": "Wed",
    "country": "Canada",
    "state": "Ontario",
    "city": "Toronto",
    "Price": 174,
    "Quantity": 22
  }, {
    "Color": "red",
    "M": "March",
    "W": "Mon",
    "Time": "1000",
    "country": "USA",
    "state": "California",
    "city": "Los Angeles",
    "Price": 1664,
    "Quantity": 19
  }, {
    "Color": "red",
    "M": "January",
    "W": "Mon",
    "country": "Canada",
    "state": "Quebec",
    "city": "Montreal",
    "Price": 1190,
    "Quantity": 292
  }, {
    "Color": "green",
    "D": "04/08/2014",
    "M": "August",
    "W": "Fri",
    "Time": "1000",
    "country": "USA",
    "state": "California",
    "city": "Los Angeles",
    "Price": 1222,
    "Quantity": 730
  }, {
    "Color": "white",
    "M": "March",
    "W": "Wed",
    "country": "USA",
    "state": "California",
    "city": "Los Angeles",
    "Price": 7941,
    "Quantity": 73
  }, {
    "Color": "red",
    "M": "August",
    "W": "Wed",
    "country": "Canada",
    "state": "Ontario",
    "city": "Toronto",
    "Price": 6829,
    "Quantity": 19
  }, {
    "Color": "green",
    "M": "January",
    "W": "Wed",
    "country": "Canada",
    "state": "Quebec",
    "city": "Montreal",
    "Price": 2995,
    "Quantity": 98
  }, {
    "Color": "white",
    "M":...