Number formatting for several measures

Integration with FusionCharts

by Flexmonster Pivot Table

HTML

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

<script src="https://cdn.fusioncharts.com/fusioncharts/3.19.0/fusioncharts.js"></script>
<script src="https://cdn.fusioncharts.com/fusioncharts/3.19.0/themes/fusioncharts.theme.fusion.js"></script>

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

CSS

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

#chartContainer {
  margin-top: 20px;
}

JavaScript

let pivot = new Flexmonster({
  container: "#pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  licenseFilePath: "https://cdn.flexmonster.com/jsfiddle.charts.key",
  toolbar: true,
  height: 400,
  report: {
    dataSource: {
      filename: "data/data.csv"
    },
    slice: {
      rows: [{
        uniqueName: "Country",
        filter: {
    exclude: ["country.[united kingdom]"]
  },
      }],
      columns: [
        {
          uniqueName: "[Measures]"
        }
      ],
      measures: [{
        uniqueName: "Price",
        format: "currency"
      }, {
        uniqueName: "Quantity"
      }],
    },
    formats: [{
      name: "currency",
      thousandsSeparator: " ",
      decimalSeparator: ".",
      decimalPlaces: 0,
      maxDecimalPlaces: -1,
      maxSymbols: 20,
      currencySymbol: "$",
      currencySymbolAlign: "left",
      nullValue: "",
      infinityValue: "Infinity",
      divideByZeroValue: "Infinity",
      textAlign: "right",
      isPercent: false
    }]
  },
  reportcomplete: function() {
    pivot.off("reportcomplete");
    createFusionChart();
  }
});

function createFusionChart() {
  let chart = new FusionCharts({
    type: "mscombidy2d",
    renderAt: "chartContainer",
    width: "100%",
    height: 500
  });

  pivot.fusioncharts.getData(
    {
      type: chart.chartType(),
      prepareDataFunction: function(data, options) {
        let output = {
          chart: {
            caption: data.meta.caption,
            xAxisName: (data.meta.r0Name != undefined) ? data.meta.r0Name : ((data.meta.c0Name != undefined) ? data.meta.c0Name : ""),
            pYAxisName: data.meta.v0Name,
            sYAxisName: data.meta.v1Name,
            formatNumberScale: "0",
						theme: "fusion",
            palettecolors: "009688,FB8C00,f2726f",
            drawCrossLine: "0"
          },
          categories: [{
            category: []
         ...