I am trying to use the merge option to create budgets and customer facing RFQ's both driven from Quotes already created in the system using the subform field.

Below is a summary of the example subform filled in from the quote I am testing with. Note, blue boxes are just hiding unnecessary fields for this question

I would like in the RFQ to customer for all the Product Types and Total Prices to just be summarized in a single line for labor, a single line for machining, and a single line for materials and so on.

The image below is the setup (so far) for the template merge using the email template criteria

The image below is the result of using a merge from the quote. As you can see, all the "Product Types" are not getting summarized in the way I would like them to, but instead are getting listed on individual lines. Is there a way to get them all to summarize using the subform table provided in the available components in the setup page?