Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I Have a Table which holds for each Product category the top 5 products.
A basic strait table is no problem (file attached), but I want to merge the Category cells for each category.
It looks s like a pivot but supposed to be much easier.
When I try to use the row span, I get the most bizarre result
I've attached the HTML code also. some of the names are in Hebrew but row span appears only once
Any help would be appreciated.
Thx.
Hi,
You can evaluate to use Levels for the Category field and nested HTML tables:
Result:
HTML code:
<html>
<body>
%%Year_Level%%
<table border="1px" bordercolor="#00C853">
<tr>
<td>%%Year%%</td>
<td>
<table>
<tr>
<td>%%Country%%</td>
<td>%%Total Sales%%</td>
</tr>
</table>
</td>
</tr>
</table>
%%/Year_Level%%
</body>
</html>
Best Regards,
Ruggero
Hi,
You can evaluate to use Levels for the Category field and nested HTML tables:
Result:
HTML code:
<html>
<body>
%%Year_Level%%
<table border="1px" bordercolor="#00C853">
<tr>
<td>%%Year%%</td>
<td>
<table>
<tr>
<td>%%Country%%</td>
<td>%%Total Sales%%</td>
</tr>
</table>
</td>
</tr>
</table>
%%/Year_Level%%
</body>
</html>
Best Regards,
Ruggero
What SR of May 2021 are you on?
Hi David.
Our version is : 21.14.3.0
Hi.
Merge cells would have been better but for now it is good enough.
Thank you