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

[former_member318041]

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

[jyothirmayee_s · Accepted solution]

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