Supermetrics Support Forum

Creating Total Field that Will Populate at bottom of Table with varying number of row


I have a table that is split by my ad sets in Facebook.  The number of rows of ad sets will vary as I bring live new ad sets and pause old ones. I would like a "Totals" row to always be at the bottom of my table.  Given that the number of rows will be varying, how do I set that up?

1 person has this question
  • Hi Chris,

    you can make a function that sums the whole row, despite of the number of cells with "=SUM(A2:A)" -but unfortunately I couldn't come up with a solution that makes a function automatically move to the end of the row of data. You could try asking Google Sheets forum if anyone knows a solution for this.

    Best regards,

    Jouni Hyötylä

    Twitter: @Supermetrics 

    Support forum: supermetrics/forum

  • Has anything become available to add a total row to Supermetrics tables in Google Sheets?

Login to post a comment

Didn't find what you were looking for?

Start a new topic