Oracle APEX Remove the aggregate totals column in an Interactive Grid

This post explains how to remove the Overall Average column on an IG when aggregates are added to an IG.  I am using APEX version 19.2 but this should work on all versions.  I added aggregates to my IG which gives me a row of averages at the bottom of the grid;

It also gives me a total averages column at the start of the grid;

There are 2 reasons I don't want this column.  Firstly, in my experience with this column its very buggy, as you can see in the picture below it causes the rows of the grid to get out of sync when sorting.  

Secondly I have a lot of columns and I want the grid to appear at 100% zoom on the browser with no scrolling and this column is taking up valuable retail space!

So.....how do we remove it?

In execute when page loads, add this JavaScript where rgBenchmarkingIG is the static ID of your Interactive Grid.

apex.region("rgBenchmarkingIG").widget().interactiveGrid("getCurrentView").view$.grid("option", "rowHeader", "none");

OK, now gone. But how does the user know that the totals at the bottom are averages?

We can use CSS to add the text Avg to the first column.  Usually first columns are names, links (like mine) etc, so we can put the text 'Avg' here ({content: 'Avg';}).  In Inline CSS add this;

#rgBenchmarkingIG_ig_grid_vc > div.a-GV-bdy > div.a-GV-w-scroll > table > tbody > tr.a-GV-row.is-aggregate.a-GV-aggregate--AVG.is-grandTotal > td:nth-child(1):after {content: 'Avg';}

Note  this is for averages (aggregate--AVG), you will need to change the CSS for sum etc.

This now tells the user the totals row is averages and gives us more space for the grid to fit on the page without scrolling;