BoldSignEasily embed eSignatures in your .NET applications. Free sandbox with native SDK available.
this.dataSourceSettings = {
enableSorting: true,
columns: [{ name: 'Date' }],
values: [{ name: 'Qty 1', caption: 'Units Sold' }, { name: 'Qty 2', caption: 'Units Amount' }],
dataSource: this.getPivotData(),
rows: [{ name: 'Product' }],
formatSettings: [{ name: 'Date', format: 'yyyy-MMM', type: 'date' }],
expandAll: false,
filters: [],
};
|
<ejs-pivotview #pivotview id='PivotView' [dataSourceSettings]=dataSourceSettings width='100%' height='300'
(enginePopulated)='enginePopulated($event)' showFieldList='true' >
</ejs-pivotview>
queryCell(args: any): void {
(this.pivotGridObj.renderModule as any).rowCellBoundEvent(args);
// Here we have customize the row headers.
if (args.data[0].valueSort && args.cell.classList.contains('e-rowsheader') && !args.cell.classList.contains('e-gtot')) {
args.data[0].formattedText = args.data[0].valueSort.axis + " : " + args.data[0].formattedText;
args.cell.querySelector('.e-cellvalue').innerText = args.data[0].formattedText;
}
}
enginePopulated(args: any): void {
this.pivotGridObj.grid.queryCellInfo = this.queryCell.bind(this);
}
|
<ejs-pivotview #pivotview id='PivotView' [dataSourceSettings]=dataSourceSettings width='100%' height='300'(enginePopulated)='enginePopulated($event)' showFieldList='true' >
headerCell(args: any): void {
if (args.node.innerText) {
var month = args.node.innerText.split('-')[1];
switch (month) {
case '01':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Jan';
break;
case '02':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Feb';
break;
case '03':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Mar';
break;
case '04':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Apr';
break;
case '05':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'May';
break;
case '06':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Jun';
break;
case '07':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Jul';
break;
case '08':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Aug';
break;
case '09':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Sep';
break;
case '10':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Oct';
break;
case '11':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Nov';
break;
case '12':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Dec';
break;
}
}
}
enginePopulated(args: any): void {
this.pivotGridObj.grid.headerCellInfo = this.headerCell.bind(this);
}
|
headerCell(args: any): void {
(this.pivotGridObj.renderModule as any).columnCellBoundEvent(args);
if (args.node.innerText) {
var month = args.node.innerText.split('-')[1];
switch (month) {
case '01':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Jan';
break;
case '02':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Feb';
break;
case '03':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Mar';
break;
case '04':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Apr';
break;
case '05':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'May';
break;
case '06':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Jun';
break;
case '07':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Jul';
break;
case '08':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Aug';
break;
case '09':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Sep';
break;
case '10':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Oct';
break;
case '11':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Nov';
break;
case '12':
args.node.innerText = args.node.innerText.split('-')[0] + '-' + 'Dec';
break;
}
}
|