Union and summarize two tables

[LuneLune]

Hello,

I have two tables.

Table 1. Green Accounts:

Table 2. Red Accounts:

I would like to union them and get the Total summary per table, as shown in the following output:

I have attached original source files and expected result. Thank you in advance for your support

Best,

LuneLune

[echuong1]

You would create each table individually, and then combine the report objects.

For example, I started by adding a total row using a Crew Macro. I then created the formatted tables with the table tool. I included a row rule to make the total line orange. I used a report text to add the account total section with appropriate colors. A union combined the two objects, and a render created the output file, a temporary excel file in this case.

You can adjust the field names and formatting, but hope this gets you started!

[LuneLune]

@echuong1 

Hi echuong1,

Thanks for your help,

Can you just share a regular workflow file instead of the packaged one?

[echuong1 · Accepted solution]

See attached. You will need to reconnect your input files.