Slice defined with rows, columns and measures
Slice configuration
HTML
<link rel="stylesheet" href="https://cdn.flexmonster.com/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<div id="pivot-container"></div>
JavaScript
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 430,
toolbar: true,
report: {
"dataSource": {
"dataSourceType": "csv",
"filename": "https://cdn.flexmonster.com/data/data.csv"
},
"slice": {
"rows": [
{
"uniqueName": "Category",
"sort": "desc"
},
{
"uniqueName": "Business Type"
},
{
"uniqueName": "Size"
}
],
"columns": [
{
"uniqueName": "[Measures]"
}
],
"measures": [
{
"uniqueName": "Price",
"aggregation": "sum"
},
{
"uniqueName": "Discount",
"aggregation": "min",
"availableAggregations": [
"min",
"max"
]
},
{
"uniqueName": "Quantity",
"aggregation": "sum"
}
],
"expands": {
"rows": [
{
"tuple": [
"category.[cars]"
]
},
{
"tuple": [
"category.[clothing]"
]
},
{
"tuple": [
"category.[accessories]"
]
}
]
}
},
"options": {
"grid": {
"type": "classic"
}
}
}
});