SQL Server Performance

Totals

Discussion in 'Analysis Services/Data Warehousing' started by abulnegel, Aug 11, 2004.

  1. abulnegel New Member

    I need to calculate qty total for all year and devide that by current stock how can I do that in mdx?
  2. Raulie New Member

    Try somthing like this....

    [Measures].[Qty]/SUM({[Time].[Year].&[2004]},[Measures].[Stock])



Share This Page