I have a cube with a distinct count measure.
I also need a measure that will give the users this measure as a percent of
the total.

For example the first measure is number of projects at various stages of
completion. The second measure will be number of projects as a %age of the
total number of products.

Please help!

Thanks in advance

--
Message posted via http://www.sqlmonster.com

I just tried the below and it seems to work! Is it correct

calc measure X
sum({[Project Status].members}, [Measures].[Count])/2

I have divided by 2 as it shows the exact double otherwise

calc measure Y

([Measures].[Count]/[Measures].[X]) * 100

thanks!

--
Message posted via http://www.sqlmonster.com