Cell merging option for table in web intelligence
Iam using the BI Query to created the universe and based on the universe i have created the webi document. In this document list out the values, i need to merge the cells for common values. But i not able to merge because i selected the rows and the cell merge property, it showing Not applicable for cell merging.
Please help me for this.How i can merge the cells in the table ?
Hi Praksah T,
You can achieve this look using the break feature. Select the country column and then the break button (it is normally left of the sort button) This will create mini tables for each of your countries. If you want it to look like a single table, click on the footer rows and click remove, then on theemply row and click remove and finally on the header row (headers appear by default for each break) and click remove row.
this will leave you data in the shap you want it but with no header. So select the table, and int he properties turn on show table headers.