It would appear that you would have to keep your table simple in terms of columns as the total row is the basis for the table calculations total, not the actual total sum of its own column This works:
