automatically aggregate the top data row of many tables into a single master table

Hi Fritz,

as I get from your question you've got the Table Filter and Charts add-on installed (as have we).

I tried to merged two tables as you described using this add-on and succeeded. I did the following:

• Table pages
  1. Create two pages (Table 1 and Table 2).
  2. Each page has a label table.
  3. Create a table on each page having the same table columns. I added a column Week to identify the week of the status report.
  4. Put each table in a Table Excerpt Macro having the same name (table).
• Master page
  1. Add the Table Excerpt include Macro to collect the tables. Use the following options:
     • Excerpt name = table (see table pages above)
     • Excerpt source = Pages with labels
     • Page labels = table (see table pages above)
     • Search in space = <insert your space here>
       
       
  2. Put a Table Filter Macro around the Table Excerpt to filter out the unwanted rows.
     • Tab Filtration: Check Hide filtration pane
     • Tab Table View:
       • Default sorting = Week highest --> lowest
       • Show first N rows = 1 (=> show only the latest week!)
     • 
  3. Put a Table Transformer around the Table Filter to merge the tables.
     • 

I hope this is what you wanted to achieve. If not, I had some nice time fiddling around with the Table Filter macros ;)

Cheers,
Kirstin