Hi Enrico,

Could you show an example of what you are trying to achieve in Excel or Word file with table with merged cells plus some small dataset example.

Attached you can find an example of the table I'd like to obtain.

Colspan for table section "Raccolta Netta Collocatori" is at the moment fixed to 10 because maximum number of "Collocatori" that can be considered is exactly 10.

In the first picture in the attached file, filters include year 2012.
The table columns are shown correctly because all 10 "Collocatori" have valid records for this period.

Unfortunately, applying filters to consider a shorter period of time, the number of "Collocatori" that have valid values (records) decreases by one.
As a consequence of this, as you can see in picture 2, one column is missing and the right border is not shown correctly due to this missing "Collocatore".

So I'd like to make value of colspan depending on the number of "Collocatori" selected by current filters (using SUBSET_UNIQUECOUNT function on "Collocatori" to determine its current value).

Thanks

Hi Enrico,

Please, try something like in the following example.

<#
var categories = SUBSET_UNIQUESLIST("Field 1");
#>

<table border=1>
<tr><td colspan="<#=categories.length#>" >Title</td></tr>
<tr>
<#for (var i=0; i<categories.length; i++) {#>
<td><#=categories[i]#></td>
<#}#>
</tr>
</table>