max sale based on year in a text box

[#1]

i am trying to display maximum sale,when aggregated by year in a text box. when i am clicking on year listbox,maximum sale is changiing

i use following function to get maximum sale aggregated with year

=max(Aggr(sum({<year,qtr>}sales),year))

[sunny_talwar · Accepted solution]

Try this:

=Max({<year, qtr>}Aggr(Sum({<year,qtr>}sales), year))

[#3]

thanks sunny