Multiple Condition Issue

[Former Member]

Hi Experts,

I have a problem of trying to utilize multiple conditions on a query. I have two conditions like this:

keyfigure A < 0

keyfigure A Bottom 10

What is happening is that it is finding the bottom 10 values and then filtering out the values. So instead of displaying 10 values, I only get a few.

I have tried changing the order of the conditions and such, but it doesn't seem to affect the results. I currently have the two conditions mentioned above in separate conditions. (My understanding is that this produces an AND effect.)

Any thoughts on how to force it to do the filtering first and then order?

Thanks in advance.

[Former Member]

Replacement query did the trick.

The first query returned all the characteristics I needed, and the they were fed into the next query.

Thank you for your assistance with this.

Points awarded.

[Former Member]

Have you tried using a pre-query? That way, the first selection is forced to happen before the second.

Here's the Help documentation... once you understand how to use it, its very powerful.

http://help.sap.com/saphelp_nw04/helpdata/EN/2c/78a03c1178ad2ce10000000a114084/content.htm

Points?

PAtrick