Question:
HI!! Is possible to use the Topn condition for all values of a caracteristics??
Examples: I want the best 3 for all the Business Unit:
BU $
1 500
400
399
2 23
19
18
3 100
99
98
Anybody can help me? Thank you very much!!
Answer:
Use the value of 3 for N. Create a query and use 'Conditions' to create your TopN. Use the characterisitc for BU and the KF that measures performance of the BU. (eg, topN customers are measured by sales, and so on).
_________________
Keep smiling
Answer:
Thank you, but in this way I have the 3 best BU with all; instead I want ALL THE BU but only for the 3 best values... is it possible?
Answer:
Please clarify your question. Do you want to see a SORTED list or do you want to see only the best 3? TopN does not display more than the value fo N specified. So if N=3, it display the best 3, if N=10, it displays the best 10, and so on.
_________________
Keep smiling
Answer:
I want to see the best 3 FOR ONLY BU but I don't know if it's possible
Answer:
Create a new condition in the query, choosing just the characteristic (BU or whatever is defined in your system). Choose the KF you want displayed, and choose the operator, TopN, and enter the value 3.
This will show only the best 3 BUs.
You should probably include a year variable in you query to show you the top 3 for different years.
If this does not help, then I have still not understood your question. Pardon me for being dumb.
_________________
Keep smiling