JavaScript
var jsonData = [
{
multiLayerDate: {type: "year/month/day"},
stringDate: {type: "date string"},
type: {"type": "number"}},
{multiLayerDate:"2020-02-05", stringDate:"2020-02-05", "type": 1},
{multiLayerDate:"2020-03-05", stringDate:"2020-03-05", "type": 1},
{multiLayerDate:"2020-04-05", stringDate:"2020-04-05", "type": 1},
{multiLayerDate:"2020-04-07", stringDate:"2020-04-07", "type": 1},
{multiLayerDate:"2020-04-15", stringDate:"2020-04-15", "type": 1},
{multiLayerDate:"2020-12-25", stringDate:"2020-12-25", "type": 1},
{multiLayerDate:"2020-05-07", stringDate:"2020-05-07", "type": 1},
{multiLayerDate:"2020-05-08", stringDate:"2020-05-08", "type": 1},
{multiLayerDate:"2020-10-09", stringDate:"2020-10-09", "type": 1},
{multiLayerDate:"2020-02-05", stringDate:"2020-02-05", "type": 1},
{multiLayerDate:"2019-10-15", stringDate:"2019-10-15", "type": 2},
{multiLayerDate:"2015-12-22", stringDate:"2015-12-22", "type": 2},
{multiLayerDate:"1857-07-13", stringDate:"1857-07-13", "type": 1}
];
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
data: jsonData,
dataSourceType: "json"
},
slice: {
reportFilters: [
{
"uniqueName": "multiLayerDate",
"sort": "desc"
},
{
"uniqueName": "stringDate"
}
],
rows: [
{
"uniqueName": "multiLayerDate",
"sort": "desc"
},
{
"uniqueName": "stringDate"
}],
columns: [
{
uniqueName: "[Measures]"
}
],
flatSort: [
{
uniqueName: "multiLayerDate",
sort: "desc"
}
],
measures: [
{
uniqueName: "type",
aggregation: "sum"
},
]
},
options: {
grid:{
type: "flat"
},
datePattern: "MM/dd/yyyy",
filter: {
...