How to find Top N and Bottom N in single Report

[Former Member]

Hi,

My requirement is to find the Top N and Bottom N in the same Query. Bottom N Condition should not consider/ignore the Zero Values. Is it possible to do in Single Query.

Regards,

Amit.

[Pravender]

You mean you want to display TOP N and Bottom N data at same point of time?

[Former Member]

Hi,

I need to display Invoice values for ex say Top 3 and Bottom 3.

Regards,

Amit.

[Former Member]

Have u tried keep both in one condition?

try once...

[Former Member]

Instead of creating two condition one for top and second for bottom ...you should create one condition and put both in one condition....In one condition all the rules are joined using a OR operation...if there are two condition or more they are joined using an AND operation.

Rgds

amit

[Former Member]

Hi,

Could you pls tell me step by step how to incorporate/add Top & Bottom N using OR Operator

Regards,

Amit

[Former Member]

You just need to create one condition....

in the same condition define two rules...one for top n and second rule for bottom n.

Rgds

amit