max function in a plot of average

[#1]

Hello, community!

I have a dataset with fields, such as: data, week(data), avg_sum_of_sales.

I want to create a text_box which contains average sum of sales per LAST week (max(week(data)) . I try to make such expression:

avg({1<[week(data)]=Max([week(data)]))>}[avg(avg_sum_of_sales)]). Whats wrong with that and how to make it right?

Thanks in advance!

Marina

[marcus_sommer]

Try this:

avg({1< [week(data)] = {"$(=Max([week(data)]))"} >} [avg_sum_of_sales])

- Marcus

[#3]

Thanks a lot!!!