get max date value

[paulwalker]

Hi Community,

I have to show max date value in straight table - for below selection i have to show max Extract date, that should be 30/07/2019 and respective value BCD -2000. 

I have tried with  : SUM({<ADV_ExtractDate={'$(=Max(ADV_ExtractDate))'}>}Amount), but it's not working .

can you please help..

Thanks in Advance!

[paulwalker]

Hi Sunny,

This is exactly what i need, but without selection showing different value. (without selection it should be club July and Aug data)

Please find the below screen.

[sunny_talwar]

Try this

Sum(Aggr(

If(ADV_ExtractDate = Max({<Service *= {"*"}>}Total <AdviserName, ContactID, Month> ADV_ExtractDate), Sum(Amount))

, AdviserName, Service, ADV_ExtractDate, %Key, ContactID, Month))