I want to create a calculated measure for average of any field of fact table.
How should I do that ???

As per formula, i need to put set and numeric value in that formula. Suppose
I want to see average of 'Sales' (field of fact table) for any combination of
dimensions then what set i should give.

Pls. advise anyone.

Probably the easiest way to create a generic average that works for any
combination is to add a "Sales Count" measure, which counts the number
of sales. The average measure is simply:

[Measures].[Sales] / [Measures].[Sales Count]

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <54fb09ddc7805@uwe>, u14323@uwe says...