Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks a lot .. It worked
Thanks for your help...
I am glad we were able to help you