1.     

[Measures].[Sales Sum] / [Measures].[Item Count]

 

If you need to take a simple average of values associated with a set of cells,

 

you can use the MDX Avg() function, as in the following example:

 

WITH

 

SET [My States] AS

 

‘{ [Customer].[MA], [Customer].[ME], [Customer].[MI], [Customer].[MO] }’

 

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ... 下一页  >>