AVG in Pivot Table when dimension is collapsed

[Anonymous]

Hi,

i have this problem: In my pivot table there are 5 dimension (year,quarter,month and other 2 dimentions).

there are more expressions in my pivot table.

I want to do a average function instead of subtotals ,on year dimension, when the quarter and month dimentions are collapsed.

anyone have any idea?

Thanks,

Luigi