Forum Discussion

zohebakber's avatar
zohebakber
Cloud Apps
07-27-2023

Rename the Pivot Grand Total

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...
dashboards & reporting
vshen's avatar
vshen
Sisense Employee
05-14-2024

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