Change column total behavior

Please, it is not fun to explain to executives, why column grand totals are not the sum of the row data in the column. It is not fun, to explain the grand total, is the formula in the context of the entire range of data and not the sum of what is being displayed.

Please, allow us to change the context of the grand total to simply be a sum of the data shown in a matrix column.

Instead we are forced to write formulas that specifically geared to accommodate grand total to sum the data. It would be so much easier to click the format of grand total to simply sum a matrix column. It would be even better to select behavior per column.