Grand total sorting

Question

Hi, I have this table And I want to add a default descending sort on the "Gran total" column, is there any way to do it?I've been reading the docs, but so far I haven't found anything that works.

AngelinFaithSheeba PaulvannanRajadurai · Accepted Answer

Hi Valeria,Using ValueSortSettings, you can sort individual value field and its aggregated values in both
ascending and descending order. Please refer the below code example.Code example:

this.dataSourceSettings = {
        valueSortSettings: {
          headerText: 'Grand Total',
          headerDelimiter: '##',
          sortOrder: 'Descending',
        },
      };

Sample: https://stackblitz.com/edit/angular-fnwg76-eewrrj?file=app.component.ts,app.component.htmlOutput screenshot:Also, please refer the following documentation for more
details about “ValueSortSettings”.Document: https://ej2.syncfusion.com/angular/documentation/pivotview/sorting/#value-sortingPlease
let us know if you have any concerns.Regards,Angelin Faith Sheeba.

Valeria de la Torre · Answer

Thank you for your help, it worked wonderfully!!Thank you so much Angelin!! 🙌

AngelinFaithSheeba PaulvannanRajadurai · Answer

Thanks for the update.
Please contact us if you have any other
queries. We are always happy to assist you.