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
YYYYY
11111Company 2
22222
33333

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.

~SwapnilY

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

Regards,

Veer

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