SQL Server Performance Forum – Threads Archive
Totals
I need to calculate qty total for all year and devide that by current stock how can I do that in mdx?Try somthing like this…. [Measures].[Qty]/SUM({[Time].[Year].&[2004]},[Measures].[Stock])
]]>
Totals | SQL Server Performance Forums
Try somthing like this…. [Measures].[Qty]/SUM({[Time].[Year].&[2004]},[Measures].[Stock])
]]>