Totals for horizontal subrange

[nikolay-atamanyuk]

Hi. I am very glad to work with ClosedXML.Report library, and it is very useful for ordinary reports. Can you help me to understands how I can template the following result, please?
I have a data source with complex property. All complex properties of the data source contain a list of equals length. Additionally, I have a list of names for every item of complex property. I try to map data source as flat table, complex property as subrange, names as horizontal table under subrange. But I need to summary by every column of a horizontal table, and I can't understand how it can be. I created an excel example of my variants, but in any case it's not working correct. Also, I tried to put horizontal range to the summary row, but it should not work, and it not work :). It looks like a pivot table, but I am not sure. Can you show me the right way for this, please?
HorizontalExample.xlsx

[Pankraty]

I would probably count totals in code and output them as a plain horizontal table, below the main one. Much easier than trying to express this via multiple <<sum>> tags.

@nikolay-atamanyuk, does this look sufficient?