Rename the Pivot Grand Total

[zohebakber]

Hi Team,
I saw a couple of scripts/solutions to rename the Grand Total in the Pivot table however, nothing seems to work maybe due to Linux enironment.
Can you help me rename the Grand Total.
Also, is there a way, I can use this Grand Total for any other widget formula.

Thanks

@Ido_QBeeQ @harikm007 

[vshen]

Hi @zohebakber ,

I know this response comes a bit late, but just in case you still need it and also for people looking for it in the future, here is a widget script to rename Grand Total for the Linux version. Tested on L2024.1 and it works:

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

Best Regards,
Volodymyr