CODEWITHSUNDEEP
business-objectswebi
Toli
Toli

Reputation: 109

Sum rows in SAP Webi 4.1 report

I have a report in Webi which is similar to below example (Upper table).

enter image description here

What I want to build is the lower table, i.e. to sum up the values of "A" and "B" and show it in one row.

How to achieve this in BO Webi?

Upvotes: 0

Views: 9432

Answers (1)

Joe
Joe

Reputation: 6827

If you are on BI4, then this is actually pretty easily done. First, Control-click on the A and B cells to select both:

enter image description here

Right-click on one of the selected cells, then hit Group -> Group:

enter image description here

Give the group a meaningful name (taking the name "A+B" from your example):

enter image description here

This will create a new Group and replace the original variable in the report block: enter image description here

You'll see the new variable under "Variables" in the Available Objects panel, and can modify it from there if necessary.

If you are not on BI4, or if you just prefer to enter a variable manually, you can do that too. Replace the Forecast column with:

=If [Forecast] InList ("A";"B") Then "A+B" Else [Forecast]

Upvotes: 2

Related Questions