Top 3 Gropped (1 Viewer)

[dz2k7]

Hi,

Let's say I have a table

Group VALUE
A 12
A 8
A 3
A 20
A 1
B 35
B 2
B 12
B 6
B 54

How I can get top 3 of each group in one veiw?

Thanks

 

[pbaldy]

I've used method 1 successfully:

http://support.microsoft.com/kb/210039/en-us

 

[dz2k7]

Thanks!
It works.