How to change column order of the Pivot Table

[Akshatha]

•  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]

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]

Thank you for the updare

[Sivamathi Natarajan]

Hi Akshatha, 

 

Thanks for reply. 

 

Regards, 

Sivamathi. 

[Manikandan Murugesan]

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