Quartiling data

[#1]

I want to quartile a group of "Primary Tickers" against a "Conviction sector" and "Year".   and join the quartile data to the right of the  table (as below). Is this an Aggr function?

PRIMARY_TICKER	Metric	Conviction Sector description	Year	Data	Sector Quartile
000001.SZ	CROCI_INCL_LEASES	Oil	CY 2004	0.15	3
000002.SZ	CROCI_INCL_LEASES	Oil	CY 2004	0.26	2
000003.SZ	CROCI_INCL_LEASES	Oil	CY 2004	0.27	1
000003.SZ	CROCI_INCL_LEASES	Oil	CY 2004	0.01	4

Many thanks in advance

[#2]

anyone have any ideas on this one?

Gysbert Wassenaar