How to find second or third Max value for each group in time series data

Hi,

I have daily data from Jan 2022 to April 2022, one of my calculation field is max amount of P&L for each Portfolio (group) .

I using following formula for it:

{ FIXED [Portfolio]: max(

{ FIXED [Portfolio], [As Of Date]: sum([PnL])}

)}

and it is working. However, sometime I need second or third max value.

How can I ignore specific date (for example April 18th) OR get second Max value in this calculation field?

 Thanks,