Hi,

I am trying to build a mdx query that will give me the relative percentage of row or column totals.My MDX is like given below:

WITH CELL CALCULATION [Five Hundred]
for '({measures.[store sales]},{[product].[all products].[Drink]} )'
as '[Measures].[store sales]/([Measures].[store sales],[product].[ALL products])', format = '#.00%'

select
{[Measures].[store sales]} on columns,
{[Product].levels(1).members} on rows
from Sales

What i get is an #ERR in the desired cell. what could be the problem where have i gone wrong..

any ideas.Please HELP

Cheers!!!