create an agregate in a calculated field?

[darkdusky]

How do you create an agregate in a calculated field?
E.g
New calculated field:
=Avg(Fields!x.Value, "datasetname")

In another thread (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=117174) visakh helped me create average columns instead of subtotals, using:
=IIF(Inscope("matrix1_Time"),Fields!x.Value,Avg(Fi elds!x.Value))

I am trying to apply this to a column already containing an average, so I get an error saying aggregates cannot be nested.
E.g.
=IIF(Inscope("matrix1_Time"),Fields!x.Value,Avg(Av g(Fields!x.Value)))
If I could place average in calculated field I might be able to refer to it instead, e.g:
=IIF(Inscope("matrix1_Time"),Fields!x.Value,Avg(Ca lculatedField)))

Or any other suggestions?

[Island1]

Are you hitting an Analysis Services data source, by any chance? MDX would offer some great options here ...

Thanks.

Bill