Rowno change sort

[#1]

Hi all!

Who can help me?

I want to create a table with 3 values in it. a code like "A23.30" a text that explains the code and a count() that counts the amount of identic codes in the table.

In the table i only want the top 20 most used codes.

So i want something like this:

Code	Text	Count()
A23.30	explanation	150
Q15.51	explanation2	95
J61.81	explanation3	55
etc	etc	etc

This is easy. My problem starts when i want to add a row number in front of the code. So i want an extra column to the left of the code column with the numberst 1 -> 20. I know RowNo() can do this. But when i add RowNo() to my expressions i can't sort count() anymore. I tried to push count() on top of the piority list in the sort tab. But when it was on top it didn't work ether.

Can somebody help me with this? how can i get a row number without lossing the sort() option on Count?

Thanks in advance to all that are willing to help!!!

[alexandros17]

Can you post your document?

[#3]

sorry it has clasified data in it. I'm not allowed to share the data in the document.

What did you want to know?

[alexandros17]

You can use scramble instruction ...

[#5]

I can show you this. There i have the 4 things i want in my table. It has to sort on Count. O and i'm sorry but I installed the Dutch version and haven't got the time to uninstall and instal the English version.