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,