Grand total sorting

[Valeria de la Torre]

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]

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.html

Output screenshot:

Also, please refer the following documentation for more details about “ValueSortSettings”.

Document: https://ej2.syncfusion.com/angular/documentation/pivotview/sorting/#value-sorting

Please let us know if you have any concerns.

Regards,

Angelin Faith Sheeba.

[Valeria de la Torre]

Thank you for your help, it worked wonderfully!!

Thank you so much Angelin!! 🙌

[AngelinFaithSheeba PaulvannanRajadurai]

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