Custom sorting and hiding columns in gridsetting toolbar

Question

We are using Sycfusion pivot grid to render data, here we want id column as internal parameter to sort the column , Example month is the description shown in the grid but we want monthid to be used to change the sort behavior, how can we achieve this.

Also we do not want monthid to be shown in the pivot grid settings toolbar which is rendered. How can we achieve this.

Sivamathi Natarajan · Accepted Answer

Hi Dileep gagan, 
 
We regret you to let you know that, we cannot achieve this requirement – “To sort the fields based on id”. Instead you can use the date grouping feature to sort date format fields. Please check the below documentation and online demo for your reference.  
 
UG: https://ej2.syncfusion.com/angular/documentation/pivotview/grouping/#date-grouping 
 
Demo: https://ej2.syncfusion.com/angular/demos/#/material/pivot-table/grouping 
 
We hope the above sample meets your requirements. 
 
Regards, 
Sivamathi.

Sivamathi Natarajan · Answer

Hi Dileep gagan, 
 
Thanks for contacting Syncfusion support. 
 
We are unable to understand the query. So, could you please provide us more details along with screen-shots/video if possible. 
 
Regards, 
Sivamathi.

Dileep gagan R · Answer

Hi Shivamani,You can see attached screenshot for your reference, where Month sort is happening in alphabetical order (April, February, January) but we have MonthId internally which we want the sorting to happen which gives (January, February, April). We are looking is there a possibility to achieve it or any even is exposed on sort change from the grid so we can have custom implementation Attachment: sorting_3fa0ec93.zip