Adding a totals row at top or bottom of a table.

[Kyle Adams]

I'm trying to add a row that represents the sum of all the values in each of the columns in a data table. However, I can't add a row with the name "Totals" in the first column, because the type of that column is Date, since the data shows statistics over a certain date range, with each date being a different row of the table. How can I override the typing that is required by the visualization table to have this new row?

[Andrew Gallant]

Set the value of that cell to null and the formatted value to "Total".