aggr() to cal the time spent on project with last updated date value

[swatitomar]

Dear All,

i am stuck while cal. the time spent in a project with the last modified date value.

Ex

project id	time	date	want result Ouput
90	6:00	16/01/2016	6:00
90	5:55	15/01/2016
92	3:00	23/01/2016
92	2:40	13/01/2016
92	1:20	30/01/2016	1:20

total will be 7:10.

in text box and pivot chart i want to show.

i tried

max(aggr(sum(time),project id,date)) but it doesn't gave correct value

Result 6:00+ 300=9:00

it add the max value rather considering on date

Thanks in Advance

swati

[swatitomar]

it is unanswerred by mistaken chosen assumed answer.

kinldy help

[sunny_talwar]

Try this:

Sum(Aggr(FirstSortedValue(time, -date), [project id]))

[MarcoWedel]

Hi,

another solution without Aggr() might be:

hope this helps

regards

Marco