Question:
Hi, I need to create a report to show the Top 10 Customers and then a line for Others. Anyone know the best way to accomplish this?
Thanks
_________________
What does not kill you makes you stronger...
(Unless you are bleeding profusely)
Answer:
This has been discussed a couple of times i think ... as far as i know (and as far as the suggestions from the forum here go), this extra line with the total is not possible with a Bex function... I had a look at his myself for a while, and the closest thing would be woth excell/vb logic if you're working with a workbook ..
Answer:
... and off course (but i think this is the obvious part that you'll already know), the top 10 is done via a condition with "Top N"...
Answer:
There is 1 workaround which I already mentioned in previous posts :
If you want for instance display the invoice value for the top 10 and for the others, create 2 KF which contain the invoice value.
Define the first Invoice value properties to be "summation" for the result, and "undefined" for the second.
The "Other" result is equal to result of the second IV minus first IV.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.