How to add a Single Result (sum/subtotal) column right in the middle of a Webi report without getting too many result columns as when we use a break option

[former_member610014]

Hi All

Thanks for showing interest in this post

The problem is that I just want one or two Result columns in a Webi report ie for a part of the data.

When I use a break I am getting the result column for all the single values/columns

But my requirement is to get the result column for the two or more columns as prefered.

The below screen shots will give you more clarity. Thanks

[former_member198519]

Create a new Coloumn next to "Kaufm. Leiter" and place the [Object] which gives you "Resultat" and then apply the second break on the new coloumn. it would give the desired result you want

[former_member610014]

Hi Ghosh

U mean Create a new column by inserting on the left or may be on the right ya ...ok

Then apply the break on the new column ? but the new column has to be named to be in the breaks list

Place the object? there is no object to place as this is the sum and it is just named as Result

And a empty new column at the end will be in the report.

[former_member198519]

ohh, I completely misunderstood the screenshot.

[Former Member]

Not clear on what basis the single sum row needs to be inserted? grouped on what columns? from the values don't see any apparent grouping.

[former_member610014]

more than one value then there should be a sum... this is the basis

[amitrathi239]

apply the break on first and third column and see.

[former_member610014]

Hi Amith

No its not working like u said.

[amitrathi239]

in the first column values are repeated in the rows and all values are different?like in first column first value is Leo and then same in the second row and different?

on which column you have applied the Break?

[former_member610014]

Hi Amith

Can u pls elaborate where to apply the break

I need the sum just below the 1751.82

and remember there should be only one result row as the Original screenshot

Thanks

[amitrathi239]

I don't think so you can achieve this by Break to create the subtotal row a very specific place.You don't have the repeated values upto 1751.82 row in any column.if you have some repeated values upto 1751.82 then break will helpful.

check if you have some other objects which you can drag in the table so that you will get some repeated values.