Sum values of unique rows

[arsallee3]

Working on problem to calculate the sum of values for the maximum created on date for each unique ID

ID	Projected Month pertains to	Created on	Projected Value
4	2015-11-01 00:00:00.000	2015-11-09 09:47:01.363	160
6	2015-11-01 00:00:00.000	2015-11-07 20:14:03.250	500
6	2015-11-01 00:00:00.000	2015-11-15 11:17:18.370	700
7	2015-11-01 00:00:00.000	2015-11-07 20:13:31.223	4000
7	2015-11-01 00:00:00.000	2015-11-16 10:29:41.813	3000
8	2015-11-01 00:00:00.000	2015-11-16 10:30:26.400	700

Result looking for is sum of the highlighted ones above, total projection would equal 4560.

Not sure if need to find this in a load or if I can get it from expression.

Appreciate any assistance.

[marcus_sommer · Accepted solution]

Try something like this: sum(aggr(FirstSortedValue([Projected Value], -[Created on]), ID))

- Marcus

[sunny_talwar]

May be use an expression like this:

=FirstSortedValue([Project Value], -Floor([Created on]))

Dimension = ID and Projected Month

[arsallee3]

Awesome, so many functions that need to learn!

Loving the program and the community and look forward to being able to assist others myself in the future!