how can i add header above of columns header using webdatarocks
this is my sample code which i'm using
var report = { "dataSource": { "data": Josndata, "excelSheetName": Report${exportFormatDate(new Date())}`, "type": "elasticsearch", "mapping": { "Column1": { "type": "string" }, "Column2": { "type": "string" }, "Column3": { "type": "string" }, "Column4": { "type": "number", }, "Column5": { "type": "number", }, "Column6": { "type": "number", } } }, "slice": { "reportFilters": [ // Top Filter { "uniqueName": "Column1", "caption": "Column 1", }, { "uniqueName": "Column3", "caption": "Column 3", }, { "uniqueName": "Column2", "caption": "Column2", } ], "rows": [ { "uniqueName": "Column1", }, { "uniqueName": "Column2", } ], "expands": { expandAll: true }, "columns": [ { "uniqueName": "[Measures]" }, { "uniqueName": "Column3", "sort": "unsorted" } ], "measures": [ { uniqueName: "Column4", aggregation: "sum", active: true, caption: "Column 4" }, { uniqueName: "Column5", aggregation: "sum", active: true, caption: "Column 5" }, { uniqueName: "Column6", formula: "\"Column4\"*100 / \"Column5\" %", active: true, caption: "Column 6", format: "customFormat" } ], "sorting": { "column": { "type": "desc", "tuple": [], "measure": { "uniqueName": "Budget_FieldDays", "aggregation": "sum" } } }, "drillThrough": [ "Column1", "Column2", "Column3", "Column4", "Column5", "Column6", ] }, "formats": [ { "decimalSeparator": ".", "decimalPlaces": 0, "thousandsSeparator": ",", name: "customFormat", currencySymbol: "%", currencySymbolAlign: "right", nullValue: "", textAlign: "right", isPercent: false } ], "options": { "grid": { "type": "classic", "showTotals": "off", "showGrandTotals": "off" //rows }, showAggregationLabels: false } } BindWebDataRocksPivot(report, true, "100%", "1000", "#pivot-container");
this end result that I want