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!

[tresesco]

Your field name in set analysis needs to be corrected, may be:

SUM({<ADV_ExtractDate={'$(=Max(ADV_ExtractDate))'}>}Amount)

[paulwalker]

I'm sorry, have written incorrect.

Updated in main  post

[tresesco]

By correcting the field name, I could get the value. Could you explain a bit more about your expected output? 

[paulwalker]

Thanks for looking it..

My output should be value should be in one level, if it is cover in ABC, should not be in another level.

Output attached in the Application.. (which i have highlight in red, should not be in)

AdviserName	Service	ABC	BCD	DEF	EFG
Andrew Savage		-	2000	2000	-
Claire Keen		2000	-	-	-
Ian Waddell (Onshore)		5300	2550	-	-
Ken McCall		3400	3400	-	-
Kevin  Taylor (Onshore)		4800	-	-	-
Regina Tan		-	13000	5000	5000

[tresesco]

This?

FirstSortedValue(DISTINCT Aggr(Sum(Amount),AdviserName, Service), -ADV_ExtractDate)

[paulwalker]

Have tried this, for JULY and ContactID - value should  be only for BCD 

It should be Maximum of ADV_ExtractDate.

[tresesco]

Try without Service in aggr(), like:

FirstSortedValue(DISTINCT Aggr( Sum(Amount),AdviserName), -ADV_ExtractDate)

[paulwalker]

No Luck!

Do you think any script issue ?

[sunny_talwar]

May be this

Sum(Aggr(
    If(ADV_ExtractDate = Max(Total <AdviserName> ADV_ExtractDate), Sum(Amount))
, AdviserName, Service, ADV_ExtractDate))