Skip to Content
0
Former Member
Sep 23, 2010 at 02:28 PM

Ranking

16 Views

Hi,

I need to get the top 3 records in the top position which have greatest sales revenue values. and the remaining records positions should be same after the top most 3 records.

I have applied Ranking, but got only those top 3 records. But i should get the remaining records also. When applying Ranking i have selected 'Bottom' check box and entered a number then as many number of records displayed after top 3 records.

What my question is, if i don't know how many number of records are there, i need to get the remaining records automatically.

Do i have any other option?

Please help me on this.

Thanks in advance,

Swathi.