Display Date for Max Value

[ACarroll]

I need to show all dates for when a value is at its maximum.

My table has 3 columns. Member_Number, Max(Advance_Equivalent) and Business_Date.

I need to show the Business_Date when the Advance_Equivalent is at its maximum for each Member_Number.

Can anyone help?

[Kushal_Chawda]

If you can share sample I will have a look at it. Make sure that you don't have any selections