Help with Structuring Email Template

[Markus_Malessa]

If anyone would be able to assist how I need to structure my email template I would greatly appreciate it. I have the following inside my template:

This produces a result such as this:

Ultimately I was hoping for this type of result however:

The main thing is that the category displayed at the top of the table in the merged cell can be anything of three different categories (In-State, Out-of-State, or Other) or multiple ones. But at most the table would be 6 columns wide with up to 3 individual categories. Any help would be greatly appreciated. Thank you.

[LeventK]

@Markus_Malessa
See it here please

docs.google.com

Email_Template_Community

Water Usage Data <<Start: ORDERBY(FILTER([TWUAOrders_fk].[Related WaterUseData],"In-State" = [TWUAUseCategory]),[TWUAUseCategory],FALSE,[Date])>><<[TWUAUseCategory]>> Period Water Used (Gallons) <<[Period]>> <<[Water_Use_Gallons]>><<End>> ...

[Markus_Malessa]

It appears that the filter is throwing an error at the moment.

Investigating to see if there is anything obvious.

[LeventK]

@Markus_Malessa
I have realized that you’re using a de-ref in your Start expression. Remove the de-ref expression inside the FILTER(…) expression and use the child records tablename instead.

[Markus_Malessa]

If you could take one more look. It seems that it has a problem when using the other table with the select/filter statement when comparing [TWUAOrders_fk] against itself and it appears that [TWUAOrders_fk] = [_THISROW].[TWUAOrders_fk] results in an undefined field error.