10 Replies Latest reply on Jan 13, 2020 3:04 PM by madhuri.tanniru

    Sort on LOD Aggregation Not Working as Expected

    Mine Safety

      I am trying to sort this table by "Quarter", then "Symbol" based on the "count of investors", and then "Investors" on the "% of portfolio" measure.

       

      I am using an LOD formula: { FIXED   [Symbol],([Date]):countd([Investor])}

       

      But for some reason some "Symbols" with a lower count of investors are appearing higher up in the table:

       

      Screen Shot 2020-01-13 at 9.02.31 AM.png