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, is there a way, I can use this Grand Total for any other widget formula.

Thanks

Ido_QBeeQ harikm007 

dashboards & reporting

1 Reply

Replies have been turned off for this discussion
  • 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