aggregate column

[Suman Kumar]

can we have different aggregate columns for different columns in pivot table?

example : column 1 has sum, column has average and like this

[Sivamathi Natarajan]

Hi Suman, 

 

Thanks for contacting Syncfusion Support. 

 

You can set unique aggregation type to each value fields. So, we have prepared a sample for your reference where we have set unique aggregation types to the bound value fields. Kindly check the below code example.  

 

Example: Column 1 (Unit Sold) is Sum, Column 2 (Sold Amount) is Average, Column 3 (Quarter) is Count. 

 

Code Example: 

 

 this.dataSourceSettings = { 

            enableSorting: true, 

            columns: [{ name: 'Year' }], 

            values: [{ name: 'Sold', caption: 'Units Sold', type: 'Sum'  }, { name: 'Amount', caption: 'Sold Amount', type: 'Avg' }, { name: 'Quarter', caption: 'Quarter', type: 'Count' }], 

            dataSource: this.getPivotData(), 

            rows: [{ name: 'Country' }], 

            formatSettings: [{ name: 'Amount', format: 'C0' }], 

            expandAll: false, 

            filters: [] 

        }; 

 

 

Please check the below screenshots of displaying different aggregated for each column. 

 

 

 

 

 

 

 

 

Meanwhile, we have prepared sample as per your requirements. Kindly check the below sample link. 

 

Sample Link: https://stackblitz.com/edit/angular-q4d2cn?file=main.ts 

 

Please let us know if you have concern. 

 

We hope that the above sample will meet your requirement. 

 

Regards, 

Sivamathi. 

[Suman Kumar]

Hi Sivamathi,

Thank you very much!! 

However, My question was row wise aggregation  for all columns.

For example, in below screenshot, application calculates "average" column for Cat,Dog and Human column but i want different function for each of they like avg,sum and count

[Sivamathi Natarajan]

Hi Suman, 

 

Thanks for your reply. 

 

Your requirement can be achieved by keeping one value axis field as reference and create separate fields with different aggregation type by using calculated fields option. Kindly check the below sample and documentation link. 

 

Sample Link: https://stackblitz.com/edit/angular-q4d2cn-7jqij7?file=main.ts 

 

Documentation Link: https://ej2.syncfusion.com/angular/documentation/pivotview/calculated-field/#calculated-field 

 

We hope the above sample will meet your requirement. 

 

Regards, 

Sivamathi.