Running Totals

Global object

by Jaffrezic

HTML

<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/2.4/flexmonster.js"></script>
<div id="pivot-container"></div>

JavaScript

var pivot = new Flexmonster({
  container: "#pivot-container",
  componentFolder: "https://cdn.flexmonster.com/2.4/",
  report: {
    "dataSource": {
      "dataSourceType": "json",
      "data": [
      {
      dimension_0: 'ma pharmacie',
      dimension_1: undefined,
      Fidélité: '',
      measure_3: 23990,
      measure_4: 4976,
      measure_5: 26.17,
      },
      {
      dimension_0: 'ma pharmacie2',
      dimension_1: undefined,
      Fidélité: '',
      measure_3: 22567,
      measure_4: -631,
      measure_5: -2.72,
      }]
    },
    options: {
              viewType: 'grid',
              configuratorActive: false,
              configuratorButton: false,
              drillThrough: false,
              showAggregationLabels: false,
              showDrillThroughConfigurator: false
            },
    "slice": {
      "rows": [{
        "uniqueName": "Fidélité",
        caption: 'Fidélité'
      },
      {uniqueName: "dimension_0"}],
      "columns": [{
        "uniqueName": "[Measures]"
      }],
      "measures": [{
        "uniqueName": "measure_3",
        active: true,
        caption: "Quantité vendue 3",
      }, {
        "uniqueName": "measure_4",
        active: true,
        caption: "Quantité vendue 4",
      }, {
        "uniqueName": "measure_5",
        caption: "Quantité vendue result",
        "formula": "(sum('measure_4')/(sum('measure_3')-sum('measure_4')))*100)",
      }]
    }
  },
  width: "100%",
  toolbar: true,
  height: 400
});