Question:
Hi All
Query:
Top N Customers
Problem:
1. The Overall Results Row shows Overall Results for all Customers.
Not Top N (eg. 10) selected.
How do I see the Summed Result only for Top n (eg. 10) selected???
2. I also want to find out the % of these Top N in Overall Result???
Tried everthing ...
BIW Gods ... plssss rescue
CMC
Answer:
me facing the same problem
Answer:
Hi,
haven't tried it, just a thought. I would try with the properties of the keyfigue : Calculate result as summation.
Sergeke.
Answer:
did you try to apply a condition, with operator TOP N and value 10? This should do the job, unless I do not understand your question...
Answer:
1. The Overall Results Row shows Overall Results for all Customers.
Not Top N (eg. 10) selected.
How do I see the Summed Result only for Top n (eg. 10) selected???
Set the properties of your key figure: Calculate result as... = Summation.
gerist
Answer:
Key Figure properties has been set to Summation.
Although it lists only Top N. In Overall Result, still it sums up for all Customers. I want to limit it to only Top N.
Answer:
It works for me...
Just a simple remark: I meant the 'Summation' setting (instead of 'Nothing defined') in Query designer and not in RSA1 for the key figure - I suppose unfortunately you meant the same...
Try to create a brand new query with only these settings - maybe your original one has other hidden features...