You can increase the Solve Order of [YTD Variance], so that it is
computed after [Measures].[Margin], to get -60%:

MEMBER [measures].[Margin] As '([Measures].[Store
Sales]-[measures].[Store Cost])/[measures].[Store Sales]',
format_string='#%'
MEMBER [Time].[YTD Current] as 'SUM(YTD([Time].[1998].[Q3]),
[Measures].currentmember)'
MEMBER [Time].[YTD Last Year] as 'SUM(YTD([Time].[1997].[Q3]),
[Measures].currentmember)'
MEMBER [Time].[YTD Variance] as '[Time].[YTD Current] - [Time].[YTD Last
Year]',
SOLVE_ORDER = 10
SELECT {[Measures].[Store Sales],[Measures].[Sales
Count],[Measures].[Margin]} on columns,
{[Time].[YTD Current], [Time].[YTD Last Year],[Time].[YTD Variance]} on
rows FROM Sales

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thank you. I am getting a -1.#J error now but I think that must be because it's trying to divide by zero or something. Thanks for the help.


"Deepak Puri" wrote: