I'm trying to get the top 3 values without doing aggregation in the expression. My top 3 deals value should be based on base_value. In script i have created the sorting order by desc based on base value. This logic was working fine when i don't have same values but not working when i have same values. Below is issue i'm facing with the logic when i use only in expression as i should not apply aggregation in the expression. Below is the sample data. Please can someone let me know how to achieve the expected output.
Expression for base value: only({<company={'ABC'},sort={"<4"}>}base_value)
The above expression repeats for the other measures.
Depending if your other fields contain information that can help you prioritise the 4th row over the 3rd, then you could consider replacing only() with FirstSortedValue().
