Question:
We have a requirment to determine top 20-50 customers only. Its not top 20 - but rather an inbetween range - 20 to 50. Any ideas?
Also we want the same report to show three summation totals:
Top 20
Top20-50
REst of customers
Any ideas?
Any help will be appreciated. Tom
_________________
Regards.
Answer:
1. Put the quey in a workbook.
2. Hide the 19 first result rows
3. Hide the rows after(or a lot) 50.
Answer:
1. Put the quey in a workbook.
2. Hide the 19 first result rows (EXCEL functionallity).
3. Hide the rows after(or a lot) 50 (EXCEL functionallity).
Answer:
1. Put the quey in a workbook.
2. Hide the 19 first result rows (EXCEL functionallity).
3. Hide the rows after(or a lot) 50 (EXCEL functionallity).
Answer:
You can use the KF Property "Calculate Single value as" and Raked List.
After, a formula in Excel will help you to search the corresponding values.
Unfortunately, there is no way to sum up the "TOP 20" values in a result (except if you create a condition and use "Calculate result as Summation").
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.