sum of last 3 years avg, deliveries syntax

[#1]

Hi!

i would like to find the avg amount from the last three years based on the key figure Delivrery total.

my mission is to find out the average consumption per week of articles.

Pseudo Code: avg(year = 2011, 2012,2013)), TotalDelivery) / 53 ( amt of weeks in a year)

I was considering using set analysis , however once again my syntax fails me;

any help would be greatly appreciated;

Brad

[Anonymous · Accepted solution]

Try this....

avg({<Year={2011,2012,2013}>} TotalDelivery) / 53