Dear all,
Apologies for yet another question.
I have the following table
I would like to pull the total of each column and have those totals listed in another table like the example below.
Is there a way to achieve this?
Cheers,
Sean.
Dear all,
Apologies for yet another question.
I have the following table
I would like to pull the total of each column and have those totals listed in another table like the example below.
Is there a way to achieve this?
Cheers,
Sean.
Yes, this is achievable. What is the primary/display column on your first table?
Hi Joseph_B,
Thanks for your reply.
The Primary Column on my first table is called Campaign.
I’ve captured the table and hidden other columns and had to change a few column names. I think this better illustrates what I’m trying to achieve.
Dear @Sean_Wood2
I reproduced your tables in a light form to show the method.
For the formula I used spaces to get it visual more structured that should support the readability.
Feel free to come back in case more support is required. I learned this also with the support of other community members and the Coda staff.
Best regards,
//JP
Dear JP,
I had no idea you could stack the formulas like this using +
This is EXTREMELY helpful.
Thank you very much. Learned a lot and solved my issue.
Cheers,
Sean.