JSFiddle - React, Tailwind, and code Playground
Demos
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
new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 550,
toolbar: true,
report: {
dataSource: {
type: "api",
url: "https://olap.flexmonster.com:9500",
index: "fm-product-sales",
mapping: {
Formula1: {
uniqueName: "Formula1",
type: "number",
hidden: false,
caption: "f1",
format: "-percentage",
formula: 'sum("Quantity") * 2',
},
Formula2: {
uniqueName: "Formula2",
type: "number",
hidden: false,
caption: "f2",
formula: 'sum("Price") * 2',
format: "-percentage",
},
},
},
slice: {
rows: [
{
uniqueName: "Category",
},
],
columns: [
{
uniqueName: "[Measures]",
},
],
measures: [
{
uniqueName: "Formula1",
formula: 'sum("Quantity") * 2',
active: true,
individual: false,
folder: "Calculated values",
format: "-percentage"
},
{
uniqueName: "Formula2",
formula: 'sum("Price") * 2',
},
],
},
},
})