Average

[alec1982]

hi,

I ahve the following table

Product     Revnue     Expense     Year

A               12%          20%          2008

A               1.2%          3.6%        2009

C               0.96%          0.46%     2010

How can I calculate the average of a product per year?

Thxs,

[#2]

I didnt understand clearly but one of these two might be what you are looking for:

Avg(Total <Product> Expense)
Avg(Total <Year> Expense)

Regards,

Kiran Rokkam.