how to apply ranking with all data

[former_member196948]

Hi All,

Good morning,

I want to know how to show top 5 records(ranking top 5) with rest all data in table

for eg.

language	total
Arabic	5
Chinese	5
English (Default)	577
Espanol	386
Hmong	2
Iloko	5
Korean	2
NONE GIVEN	17
Not Provided	70
Persian	4
Russian	2
Samoan	2
Tagalog	13
Undetermined	2260
Vietnamese	5

after applying rank
language	total
Undetermined	2260
English (Default)	577
Espanol	386
Not Provided	70
NONE GIVEN	17

I want to show rest also means (final result should be like this)

language	total
Undetermined	2260
English (Default)	577
Espanol	386
Not Provided	70
NONE GIVEN	17
Arabic	5
Chinese	5
Hmong	2
Iloko	5
Korean	2
Persian	4
Russian	2
Samoan	2
Tagalog	13
Vietnamese	5

top 5 values coming from applying ranking and after that rest all are in the table

i am using 3.1 infoview.

Thanks in advance,

Ranjeet

[Former Member]

Hi Ranjeet,

Do you want all the values in that table.. Apply Descending order in  the total column.

I am not sure hope useful to your requirement.

Regards,

G

[former_member196948]

Hi Bhargav,

Thanks for your reply, i want all values in the table

Descending order will reflect values for all i want top 5  with rest of values

language	total
Undetermined	2260
English (Default)	577
Espanol	386
Not Provided	70
NONE GIVEN	17
Arabic	5
Chinese	5
Hmong	2
Iloko	5
Korean	2
Persian	4
Russian	2
Samoan	2
Tagalog	13
Vietnamese	5

top 5 are coming with rank 5 and rest are coming as it is as real data

please suggest

Ranjeet

[former_member183330]

Hi Ranjith,

Not able to get your requirement, sorry to this.

Could you please explain clearly and just give the out put what you are getting and give the sample data how you want.

Thanks,

[arijit_das]

Well, then you have to use 2 blocks with fixed column width joined together using relative positioning.

[former_member196948]

Hi Sampath,

this is output from database

language	total
Arabic	5
Chinese	5
English (Default)	577
Espanol	386
Hmong	2
Iloko	5
Korean	2
NONE GIVEN	17
Not Provided	70
Persian	4
Russian	2
Samoan	2
Tagalog	13
Undetermined	2260
Vietnamese	5

if i apply ranking (top 5) i am getting this out rest all are not coming due to ranking

language	total
Undetermined	2260
English (Default)	577
Espanol	386
Not Provided	70
NONE GIVEN	17

my requirement is like below

language	total
Undetermined	2260
English (Default)	577
Espanol	386
Not Provided	70
NONE GIVEN	17
Arabic	5
Chinese	5
Hmong	2
Iloko	5
Korean	2
Persian	4
Russian	2
Samoan	2
Tagalog	13
Vietnamese	5

means after top 5 rest all values will also be there is report

please ask if you want any more information..

Ranjeet

[former_member183330]

Create variable Use below logic

=Rank([total];[language])

drop this variable besides the above mentioned 2 fields you will get the rank numbers, sort based on this variable.

or

if need the same sort order like you given above then se the below logic:

=If(Rank([total];[language])<=5;1;2)

drop this variable in front column of the table .

Thanks

[former_member196948]

hi Sampath

i dont want to use sorting on records if u see my sample report after top 5 values are  like 5,2 ,13.

after top 5 it is mixture of data no sorting apply 

ranjeet

[arijit_das]

I really do not understand what kind of business need is satisfied by such representation of data. Why can't you just show the data in descending order ?

[former_member183330]

Ranjeet,

you can show the data as you wish use below logic.

=If(Rank([total];[language])<=5;Rank([total];[language]);6)

use this variable in first column of the table and hide the column.

but as arjith said there is no logic for your requirement.

Thanks,

G Sampath Kumar