Sort order given by a hidden aggregation
Slice configuration
by ezk84
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
let pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
filename: "data/data.csv"
},
mapping: {
"Price": {
/* visible: false */
}
},
slice: {
rows: [
{
uniqueName: "Country",
},
],
columns: [
{
uniqueName: "[Measures]"
},
{
uniqueName: "Category",
},
],
measures: [
{
uniqueName: "Discount"
},
{
uniqueName: "Price"
}
],
sorting: {
column: {
type: 'desc',
tuple: [],
measure: {
uniqueName: 'Price',
aggregation: 'sum',
}
}
}
}
}
});