Take nth row from Aggr?

[Anonymous]

Hi All,

I have this aggr function

aggr(count(XXX)/sum(YYY),Date)

COUNT(XXX)/SUM(YYY) is calculating acheivement percent, what I'm looking for, is to get the date when it reached 98%, firstsortedvalue is not working (at least in the way I'm using it) because it is giving me the top date (equal to 100%). How can I limit the result of aggr only to be those >=98% so I can use firstsortedvalue.

Or if you have any other solution I'd really appreciate it, thanks in advance!

[#2]

Could you share your qvw or some sample data?

[Anonymous]

Here it is, I'm trying the formula in the blue text box