JSFiddle - React, Tailwind, and code Playground
Other
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>
CSS
#fm-pivot-view
> div.fm-ui-element.fm-ui.fm-ui-container.fm-ui-window.fm-ui-popup.fm-filter-view.fm-noselect
> div.fm-ui-element.fm-ui.fm-ui-container.fm-filter-view-content
> div.fm-ui-element.fm-ui.fm-ui-row.fm-filter-sort-row
> div.fm-ui-element.fm-ui.fm-ui-col.fm-filters-col
> button.fm-filter-btn[aria-label="Filter by: Dates"] {
display: none !important;
}
JavaScript
let pivot = new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
height: 600,
toolbar: true,
report: {
dataSource: {
type: "microsoft analysis services",
proxyUrl: "https://olap.flexmonster.com:8085/",
catalog: "Adventure Works DW Standard Edition",
cube: "Adventure Works",
binary: true,
},
slice: {
rows: [{
uniqueName: "[Product].[Product Categories]",
}, ],
columns: [{
uniqueName: "[Date].[Calendar]",
},
{
uniqueName: "[Measures]",
},
],
measures: [{
uniqueName: "[Measures].[Internet Total Product Cost]",
format: "currency",
},
{
uniqueName: "[Measures].[Internet Average Sales Amount]",
active: false,
format: "currency",
},
{
uniqueName: "[Measures].[Gross Profit]",
active: false,
format: "currency",
},
],
drills: {
rows: [{
tuple: [
"[Product].[Product Categories].[Category].&[4]"
],
},
{
tuple: [
"[Product].[Product Categories].[Subcategory].&[28]"
],
},
{
tuple: [
"[Product].[Product Categories].[Subcategory].&[25]"
],
},
],
},
memberProperties: [{
levelName: "[Product].[Product Categories].[Product]",
properties: ["List Price", "Start Date"],
}, ],
},
options: {
showMemberProperties: true,
},
formats: [{
name: "",
thousandsSeparator: ",",
decimalSeparator: ".",
decimalPlaces: 2,
}, {
name: "currency",
currencySymbol: "$",
}],
},
});