Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Merge option in Excel and WEBI report

Hi Experts,

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.

PricesCompany Name
XXXXXCompany 1
YYYYYCompany 1
11111Company 2
22222Company 2
33333Company 2

Our requirement is to merge the duplicate entries of the column "Company Name" as below and to create a webi report.

PricesCompany Name
XXXXXCompany 1
11111Company 2

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.


Former Member replied

Hi Swapnil,

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 :-)



1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question