Set analysis to show top performing country and should neglect all selections

[Qlikuser225]

Hello,

I want to show a ref line in gauge chart in qlik sense which shows top performing country per selected month (default is current month) and it should not change if i select other countries. 

Load * inline [

Country  Records    Month

USA       11               Feb-2025

Brazil      9               Feb-2025

Canada   8               Feb-2025

USA        9               Jan-2025

Brazil      20               Jan-2025

Canada   13              Jan-2025

I want to show Ref line with 11 on gauge chart for Feb-2025 and it should not change if i select Canada or Brazil. Same as Ref line should be 20 for Jan-2025 and it should not change if i select USA or Canada.

Can anyone pls help me with this?

Thanks in Advance

[Chanty4u]

Try this 

Max({<Country=, Month=P(Month)>} Aggr(Sum(Records), Country, Month))