JSFiddle - React, Tailwind, and code Playground
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
const pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
data: getData(),
mapping: {
Time: {
type: "number",
},
},
},
slice: {
rows: [
{
uniqueName: "Color",
},
],
columns: [
{
uniqueName: "[Measures]",
},
],
measures: [
{
uniqueName: "Price",
aggregation: "sum",
},
{
uniqueName: "Time",
aggregation: "sum",
},
],
},
},
})
function getData() {
return [
{
Color: "green",
Country: "Canada",
State: "Ontario",
City: "Toronto",
Time: 2.5,
Price: 174,
Quantity: 22,
},
{
Color: "red",
Country: "USA",
State: "California",
City: "Los Angeles",
Time: 3,
Price: 166,
Quantity: 19,
},
{
Color: "blue",
Country: "USA",
State: "Florida",
City: "Tallahassee",
Price: 215,
Time: 5.5,
Quantity: 25,
},
{
Color: "black",
Country: "Canada",
State: "Quebec",
City: "Montreal",
Time: 6.7,
Price: 194,
Quantity: 15,
},
]
}