I promise no more after this one Gysbert! !
I also want to quartile the data you have created in the attached against another field in my model called "Conviction Sector description"
So essentially I want to quartile a group of "Primary Tickers" against a "Conviction sector" and "Year". and join the quartile data to the same 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
I appreciate this is probably pushing it - but any help would be most grateful.