Oracle APEX Interactive Grid rename aggregate row label

This post describes how to rename an Interactive Grid aggregate totals row name.  I am using APEX 19.2.

The default name is "Overall Sum" for the totals row, this was knocking out the other rows slightly so I needed to make it "Total" instead.

The solution was to add the following JavaScript into the function and Global Variable Declaration.

The JS is as follows;

/******************************************************************************************

* The spreadsheet (IG) totals default name is "Overall Sum".  Rename it "Total".

* 

* Param spreadsheetID : The Interactive grid ID

*******************************************************************************************/

function renameOverallSumToTotal(spreadsheetID) 

{      

     var g = apex.region(spreadsheetID).widget().interactiveGrid('getViews', 'grid');          

     var labels = g.view$.grid('option', 'aggregateLabels');      

     labels.SUM.label = 'Subtotal';      

     labels.SUM.overallLabel = 'Total';   

     g.view$.grid('option', 'aggregateLabels', labels);      

  

     g.view$.grid('refresh');

}

// Rename the totals rows on both spreadsheets

$('#pgrCalculation').on('interactivegridviewchange', function(event , ui)

 {    

    renameOverallSumToTotal('pgrCalculation');

});

where pgrCalculation is the static ID of the Interactive Grid