TOP N condition not working
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!
Hi check with this link ...
try creating a condition on that particular keyfigure ..
Edited by: Shikha Goel on Sep 19, 2008 8:55 PM