Merge option in Excel and WEBI report
I have been working on a requirement wherein I have to create a WEBI report based on an excel file in BO3.1.
If I create a WEBI report based on the table below. it works as expected.
Our requirement is to merge the duplicate entries of the column "Company Name" as below and to create a webi report.
I have created a webi report based on the above table which has merged cells, however it did not work as expected. Please have a look at the screenshot below.
This report should have the merged cells as we have them in the excel file. I have tried this in BI4.1SP06 as well, however got the same results.
I am not a developer but still I have tried my best to explain our issue and the requirement.
Appreciate all your help.
This can achieve by applying Breaks on company name.
Please follow the steps mentioned below:
1. Right click on table and Goto "Break" -> Click "Manage Breaks"
2. Click on Add button and add Dimension "Company".
3. On right hand side you will see drop down for "Duplicate Values" -> Select "Merge" in it.
4. Now click OK.
Hope this will help you :-)