Display Table filters on Merged Tables

Monica Lavin

I'm new to macros, so I'm looking for guidance on how to best combine macros to get my desired result. 

 

In my space, I have a several pages that include multiple tables each, all tables have the same column headers and Table Filters added to them. 

 

On a different page in the same space, I'd like to 'merge' all of the tables into 1, keeping the Table Filters. Then, I'm adding a Gantt chart to the 'merged' table. 

 

I've attempted to use a series of Excerpt Table, Excerpt Table Include, Table Transformer macros, but everything I try results in the 'merged' table NOT showing the filter options, but all the individual tables show below, with the filters. 

Stiltsoft support

Hi @Monica Lavin ,

I suggest referring to our support where you'll be able to share your screenshots confidentially and we will guide you through the case.

As far as I see from you description, if you have multiple tables with the same headers, you may wrap them into the Table Excerpt macros. Seems that it is what you do now.

Then on your master page you collect them via the Table Excerpt Include macro. Here in the macro settings you tick the "Show as a report" option and all your tables are merged into one big table automatically. You don't need the Table Transformer macro to merge your tables in this case.

Then you wrap your Table Excerpt Include macro in the Table Filter macro and set the required filters.

The last step will be to wrap your Table Filter macro in the Chart from table macro.