How to change column order of the Pivot Table

Question

I want to change order of the column "Grand Total" to beginning, currently which is displaying at the last column.
How do I freeze the "Grand Total" column.
How to implement sever side lazy loading when we scroll horizontally and vertically.

Sivamathi Natarajan · Accepted Answer

Hi Akshatha, 
 
Thanks for contacting Syncfusion support. 
 




Query 

Response 


I want to change order of the column "Grand Total" to beginning, currently which is displaying at the last column. 

We have already logged your requirement – “Provision to display grand total at first” as a feature task in our database and it will be available in any one of our upcoming release. You can track the task in the following link. 
 
https://www.syncfusion.com/feedback/18372/ 
 


How do I freeze the "Grand Total" column. 

The row and column headers are in fixed position (frozen) by default in the pivot table component. So, doing the same thing for the grand totals would make UI odds. Therefore, the provision could not be implemented. 


How to implement sever side lazy loading when we scroll horizontally and vertically. 

The pivot table uses lazy loading concept in virtual scrolling feature. In virtual scrolling, you can bind large amount of data up to 1 million in count. Please find the below UG and online demo links for more information. 
 
Please find the below UG and sample link for your reference. 
 
UG: https://ej2.syncfusion.com/angular/documentation/pivotview/virtual-scrolling/#virtual-scrolling 
 
Online Demo: https://ej2.syncfusion.com/angular/demos/#/material/pivot-table/virtual-scrolling 
 
 
Please let us know if you have concern. 
 
Regards, 
Sivamathi.

Akshatha · Answer

Thank you for the updare

Sivamathi Natarajan · Answer

Hi Akshatha, 
 
Thanks for reply. 
 
Regards, 
Sivamathi.

Manikandan Murugesan · Answer

Hi Akshatha, 
We are glad to announce that our Essential Studio 2021 Volume 4 Main Release V19.4.0.38 is rolled out and we have provided support “Provision to display grand total at first”. Kindly refer to the following code example and sample to display grand totals at first. 
 
Code Example: 





    this.dataSourceSettings = { 
      grandTotalsPosition: 'Top', 
    }; 
  } 
   
 
Sample: https://stackblitz.com/edit/angular-5siud9?file=app.component.ts 
Release Notes: https://ej2.syncfusion.com/angular/documentation/release-notes/19.4.38/?type=all#pivot-table 
 
We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 
 
Regards, 
Manikandan

Query	Response
I want to change order of the column "Grand Total" to beginning, currently which is displaying at the last column.	We have already logged your requirement – “Provision to display grand total at first” as a feature task in our database and it will be available in any one of our upcoming release. You can track the task in the following link. https://www.syncfusion.com/feedback/18372/
How do I freeze the "Grand Total" column.	The row and column headers are in fixed position (frozen) by default in the pivot table component. So, doing the same thing for the grand totals would make UI odds. Therefore, the provision could not be implemented.
How to implement sever side lazy loading when we scroll horizontally and vertically.	The pivot table uses lazy loading concept in virtual scrolling feature. In virtual scrolling, you can bind large amount of data up to 1 million in count. Please find the below UG and online demo links for more information. Please find the below UG and sample link for your reference. UG: https://ej2.syncfusion.com/angular/documentation/pivotview/virtual-scrolling/#virtual-scrolling Online Demo: https://ej2.syncfusion.com/angular/demos/#/material/pivot-table/virtual-scrolling