on 11-01-2004 6:00 AM
Hi Expert,
Need help from all of u, How to create total others from the rest of TOP N. let say I have 10 record and I generate report with top 5 and the rest record not listed and I want put the rest in total others.
Sample report:
Div Sales
A 39.737
B 4.589
C 3.172
D 2.159
E 1.672
Other 3.671
Overall 55.000
Highly appreciate of your concern about it.
Thank you
supriatna
Hi Supriatna,
the easiest (and cheesiest) way is to do it in Excel. Copy the cells of a TOP N query on another sheet and insert the row manually.
In the web you could do it with the table interface though it is quite a hassle to program.
You could also try it with a prequery or a precalculated result set (in the reporting agent). But those solutions are both a bit unflexible.
You could also do it with exit variables but that could be quite complex.
If you need any code example or detailed explanantion feel free to ask.
Best regards
Dirk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dirk,
It would be great if you could mail me that code which would help me in implementing this (total TOP N and total Others) in my queries.Its a critical task at hand and a very URGENT requirement.
I would really apreciate your gesture.
Thanks in advance
Regards,
Priya
priyagangwani@gmail.com
Message was edited by: Priya Gangwani
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.