To Display in text object max(cost) corresponding with year

[Hareeshkommineni]

LOAD * INLINE [
Year, cost
2010, 1000
2013, 2000
2014, 9000
2016, 6000
2018, 5000

];

i want to add missing years and

I want output like this in text object

2014=9000

[sunny_talwar · Accepted solution]

Try this

=FirstSortedValue(Year, -Aggr(Sum(cost), Year)) & '=' & Max(Aggr(Sum(cost), Year))

[sunny_talwar · Accepted solution]

Or this if you only have a single cost for each year

=FirstSortedValue(Year, -cost) & '=' & Max(cost)

[Hareeshkommineni]

tq so much
it's very usefull