Latest value for each year

[Anonymous]

Hi Everyone,

I want to include two years of data into the report and i need to find latest value based on date column for each particular year.

For 2018 the latest value is 3000. For 2017 latest value is 1000.

Rec No	Name	Date	Value
1	A	1/1/2018	1000
2	A	1/2/2018	2000
3	A	1/3/2018	3000
4	A	1/1/2017	1000
5	A	1/2/2017	3000
6	A	1/3/2017	1000

Thanks in Advance

[sunny_talwar]

In text box object... you can try this

=Avg(Aggr(FirstSortedValue(Value, -Date), Name, org, Year_Org))

When org = 12300 is selected

When org = 12301 is selected

[Anonymous]

Thanks a lot .. It worked

[Anonymous]

Thanks for your help...

[sunny_talwar]

I am glad we were able to help you