JSFiddle - React, Tailwind, and code Playground

Customizing the grid

by Flexmonster Pivot Table

HTML

<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

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

JavaScript

var DividiPerDato = 1;
var measureValori = {};
if (DividiPerDato === 0) {
  measureValori = {
    uniqueName: "Valori",
    aggregation: "sum",
  }
} else {
  measureValori = {
    caption: "Weighted Average",
    uniqueName: "weighted_avg",
    formula: "sum('Valori') / sum('Divisor')",
  }
}

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    dataSource: {
      data: getData(),
    },
    slice: {
      rows: [
        {
          uniqueName: "G1",
        },
      ],
      columns: [
        {
          uniqueName: "Anno",
        },
        {
          uniqueName: "Mese",
        },
        {
          uniqueName: "[Measures]",
        },
      ],
      measures: [measureValori],
      expands: {
        expandAll: true,
      },
    },
    options: {
      grid: {
        showTotals: "off",
      },
    },
  },
})

function getData() {
  return [
    {
      G1: "Reddito Netto",
      G2: " EBITDA",
      G3: "Profitto Operativo Lordo (GOP)",
      G4: " Profitto dei Reparti Operativi",
      G5: "Costi Operativi",
      G6: " Camere",
      Anno: "2025",
      Mese: "Gennaio",
      Valori: 10,
      Divisor: 100,
      Livello: "L.5",
      G7: "",
      Link: "L.5 -7/11",
      G8: "",
      G9: "",
      G10: "",
      G11: "",
    },
    {
      G1: "Reddito Netto",
      G2: " EBITDA",
      G3: "Profitto Operativo Lordo (GOP)",
      G4: " Profitto dei Reparti Operativi",
      G5: "Costi Operativi",
      G6: " Camere",
      Anno: "2025",
      Mese: "Febbraio",
      Valori: 20,
      Divisor: 50,
      Livello: "L.5",
      G7: "",
      Link: "L.5 -7/11",
      G8: "",
      G9: "",
      G10: "",
      G11: "",
    },
  ]
}