Hi All, I have 12 tables in 12 sections and am trying to create a summary of costs for all tables. I have created a table with each column representing a table. I have pulled the total of each of the tables into it’s own column. [31] How can I make a table where I have a vertical list of table…

Hi Sean, were you able to find a solution for this? I am facing the same problem. Thanks

Are all the tables the same structure or different? If they’re the same then the solution would be simply to have one table and 12 views with appropriate filtering for each section. Calculating the totals would then be trivial. Do you have an example doc we can look at?

Hi Nick, they are not the same structure in my case. Thinking outside of the box, another approach for me would be to successfully reference a table name that is a variable. Not sure if that is possible with coda. I don’t know if its possible to access a list of all table names within a doc for in…

Hey, is there any simple solution about this?

Dear @Anom_Birowo , welcome to the community! Credits to Paul for his approach on transposing tables: [image] Transpose table A makeshift solution, but you can make a separate table that will look up data from your original table in a transposed way. It will be read-onl…

Thanks, it works. The next problem is how to hide it so the source table won’t be visible? For example if you want to print it

Hi @Anom_Birowo , Great news.:pray: You can create another page, in the same doc, and move it there :thinking:

Summary of multiple tables

Nick_Milner May 7, 2019, 1:36pm 5

It sounds like what you’re describing is a requirement to union two or more tables. There’s a nice example of how to combine data from multiple tables here: Data Hierarchy and Aggregration

Topic		Replies	Views
Calling information from multiple tables in a table	3	2135	February 19, 2021
Table of summary data from multiple tables	10	403	July 15, 2024
How to combine multiple Tables together into a single big table	5	2021	December 21, 2022
Table with single select of subtables to pull the sum	9	3177	July 1, 2019
Get a summarize from different tables	2	234	January 10, 2024

Summary of multiple tables

Related topics