Knowledge Base Article

Changing the ‘Grand Total’ label on pivot table

*****Windows Only**** When having a pivot table which contains more than one value and present the grand total for each of the values, the total row is called “Grand Total” In some cases you c...
Updated 11-08-2024
Deploy: Windows
Laris_Fdz's avatar
Laris_Fdz
Cloud Apps
01-18-2022

pivot2 version

widget.transformPivot(
{type: ['grandtotal']},
function (metadata, cell) {
if(cell.content == 'The title to be changed') {
cell.content = 'The new title';
}});

P.S. And I am looking for a way to move Grand Total to the first row. Has anyone achieved it?

About Widget & Dashboard Scripts

Node avatar for Widget & Dashboard Scripts
200 ArticlesCreated: 6 months agoLatest Activity: 04-15-2025