TOP N condition not working

[Former Member]

Hi experts!

I have a query with a condition that applies to the KF "Total values". Its operator is a TOP N and its values are entered by the user with a variable in the preselection criteria of the query.

This condition have a combination of 22 characteristic (not all characteristic posibles).

When I execute the query with any value in the variable, it doesn't work. For example, if I execute with value = 10, the query return me a lot of records and not the 10 highest.

If I change the combination of the characterist and I select only one, the query returns me the highest records of this characteristis.

So, Have anybody had the same problem? I mean the TOP N doesn't work. Could you help me?

Thanks in advance!

Regards!

Alejandro

[Former Member · Accepted solution]

Hi check with this link ...

http://help.sap.com/saphelp_nw04/helpdata/en/73/702e39074dc93de10000000a114084/content.htm

try creating a condition on that particular keyfigure ..

Edited by: Shikha Goel on Sep 19, 2008 8:55 PM

[Former Member]

All characteristics most be together in the rows of the query

Thank a lot Shikha!!!