1 Reply Latest reply: Nov 10, 2014 4:52 AM by Roderick McKeown RSS

    Quartiling data

      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_TICKERMetricConviction Sector descriptionYearDataSector Quartile
      000001.SZCROCI_INCL_LEASESOilCY 20040.153
      000002.SZCROCI_INCL_LEASESOilCY 20040.262
      000003.SZCROCI_INCL_LEASESOilCY 20040.271
      000003.SZCROCI_INCL_LEASESOilCY 20040.014

       

       

      Many thanks in advance