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:
