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
