frequency

[Toppler]

Hello all,
I have the following sample order id

Order

a

b

c

d

d

d

e

e

how can the absolute frequency be represented in the following target form?

frequent	number
1	3
2	1
3	1

Thanks four your help. 

Greetings

Tobias 

[Toppler]

sure. 

i have orders that occur more often in my query. in the following list i can see the frequency of the individual orders.

now i would like to know how many orders occur once, twice, three times and so on?

it will look something like this. i cannot currently display this with my data.

[Toppler]

Has anyone an idea? 

[Arul]

@Toppler ,

sorry it was not clear. Could you explain bit more in detail?

Thanks,

Arul