Add a Total Row at the bottom with custom formulas

[creativFuture]

Hi I have the following project where I have sample marketing data.

Sample data

In the source sheet I have a row at the bottom that tallies up the columns. Some of the columns are sums as others are simple equations such as the Ad Spend Column divided by the Outbound Clicks Column. As "Total" is not a date, I get invalid date at the bottom of the column. If I set the date column to plain text the dates read as date numbers (i.e. 45303) instead. Id like to be able to generate these same formulas within a row in appsheet. I wish I could add a "virtual row." Also worth noting, its not worth it to export the data from google sheets into appsheet database, because these numbers update regularly, especially the ones in the current month, and so far I haven't seen appsheet database live update from source sheet.

The long and short of it all is can anyone please tell me how I can have a "totals" row at the bottom of the table? 

Thank you all very much for your time and help in advance!

[Joseph_Seddik]

You need to have a separate Months table, and establish a reference towards it from your existing table. In the Months table you can show the totals of the different columns among all rows referencing that month. 

To work with AppSheet, it is important that you have knowledge about database design. Please study this guide and follow the links inside: Data: The Essentials - AppSheet Help

[creativFuture]

Hi Joseph,

Thank you for your response. I do have a separate table with the totals, but I was hoping that at the bottom of the view in the screenshot I attached could show totals. So far ive been able to achieve this by converting all the dates to text in the google sheet and setting the columns type to text. However I was hoping there would be a way to calculate the totals within appsheet instead.