looker column totals

[Parin_Shah]

I have a calculated filed in looker that is using table calculations based off another column.

When i select totals to get the column totals the calculated column total comes incorrect. I understand this is due to the reason mentioned here, but is there a way to get the correct total (using table calculations or some other element).

If i use the  sum(${view_name.field_name}) then i get a new column but what i need is a new row (total).

Example: