How to add a row with a calculation and transformation

Once you do such a thing, you will have only character columns, so you wont be able to calculate on that frame anymore. i.e. reporting dataframes are 'the last step' in a workflow.

Your issue seems similar to this one that I answered recently...

Though your case is perhaps simpler as you dont want the summary info in seperate columns but in the same columns.