.
...
The previous tutorial, Using Grouping and Nesting with ExcelTemplate (deprecated), showed how to use the new %%group marker to group hierarchical data from a flat data set. In this tutorial, we expand upon the concept by introducing advanced features: headers and footers for each group, the %%value() marker to show data values in headers and footers, the (hide) modifier to hide data that is already shown in a header or footer, and formatting options.
...
This tutorial uses the same code and data as the previous tutorial, Using Grouping and Nesting with ExcelTemplate (deprecated). The template used in this tutorial starts where the previous tutorial left off.
...