cancel
Showing results for 
Search instead for 
Did you mean: 

Total Others and TOP N

former_member378832
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Dirk,

i am interested in code exampples on how to solve this problem. Especially in Web. Can you help me? We are trying many things but nothing work?

Regards,

M. Erbil

former_member378832
Participant
0 Kudos

Hi Dirk,

I found another way by creating 6 restrict key figure 5 for div and 1 for the rest it works but is not flexible.

I am interested with ur code example and ur explanation with step-by-step solution, Please show me or mail me?

Best regards,

supriatna

Former Member
0 Kudos

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