Skip to Content
0
May 11, 2018 at 08:49 AM

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

69 Views Last edit May 13, 2018 at 01:09 PM 2 rev

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

Attachments

pgf7z.png (2.1 kB)
izcxf.png (5.5 kB)
zfpik.png (3.8 kB)
d4x0s.png (2.0 kB)