Skip to Content
0

How to extend area of validity?: table --> report

May 11 at 08:49 AM

32

avatar image

Hi all,

I am working with "SAP BusinessObjects Business Intelligence 4.2" and have the following problem.

I need to restrict a table by certain rows, before I can make further calculations on it.

The scope of these restrictions should be valid on the whole report, not just on a part of it.
What I need to do is just to use the rows of the table that have the highest value in the field [field-2] for each [field-1].

I have lerarned, that this can be archieved by putting the formula

=Max([field-2])In([field-1])

directly into the the table.

This gives me the desired result:

This looks pretty perfect in the first place, but I need to perform further calculations on the above table with the desired result.
When I do further calculations, the results does not refer to the above table with the desired result, but to the initial table as the scope of the desired results is limited to the table itself!

When I count the values of [field-2] I expect a result of 2, but I receive 4 instead!

=Count([field-2])


I need the scope of the desired results to be valid in the whole report, not just in the specific table!

How can this be solved?

TIA,
Henning

pgf7z.png (2.1 kB)
izcxf.png (5.5 kB)
zfpik.png (3.8 kB)
d4x0s.png (2.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jyothirmayee A May 14 at 09:01 PM
0

Hi,

Try =Count([Maxformula])

Also, you can restrict your report to specific values with in WebI query Panel too.

Use Query Filter to predefine filters and that filter value will restrict whole report result set.

Thanks,

Jothi


Share
10 |10000 characters needed characters left characters exceeded