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

# Sort on LOD Aggregation Not Working as Expected

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:

• ###### 1. Re: Sort by Field Sum Aggregation Not Working as Expected

Have you tried LOD?

• ###### 2. Re: Sort by Field Sum Aggregation Not Working as Expected

Yeah I'm using it now, but maybe it needs to be tweaked:

{ FIXED   [Symbol],([Date]):countd([Investor])}

• ###### 3. Re: Sort by Field Sum Aggregation Not Working as Expected

I tried this LOD too {FIXED [Date],[Symbol]: COUNT([Investor])}

• ###### 4. Re: Sort by Field Sum Aggregation Not Working as Expected

Using this  {FIXED [Date],[Symbol]: COUNT([Investor])} we can see the count of the Investors, the only thing left is how to sort it out, we are close to the answer.

• ###### 5. Re: Sort by Field Sum Aggregation Not Working as Expected

The original LOD I used also showed the count of investors so I'm not sure it's any different. But even using your formula, I still get stuck at the same part...

• ###### 6. Re: Sort by Field Sum Aggregation Not Working as Expected

Thanks

• ###### 7. Re: Sort on LOD Aggregation Not Working as Expected

Thanks but it still doesn't sort the symbol by the count of investors. See screenshot where a symbol with a count of 7 appears above one with a count of 8, and another where a count of 3 appears before a count of 5.

• ###### 8. Re: Sort on LOD Aggregation Not Working as Expected

This is what I see when the "Symbol" pill is sorted the way it is on the screenshot

Thanks

• ###### 9. Re: Sort on LOD Aggregation Not Working as Expected

When I open your file, there is no sort on "Symbol". Not sure if it makes a difference but I'm on 2019.1.3

Can you share a screenshot of the Symbol Sort screen? Here is mine:

• ###### 10. Re: Sort on LOD Aggregation Not Working as Expected

Please see now and I am not sure why "nested sort" didnt work.

Thanks