Hi experts,

I was writing the below MDX query

WITH CELL Calculation [Final] FOR '([Measures].[Status Sum],[date].[Fiscal Year].allmembers,leaves([Customer]))'
AS Aggregate({NULL:[date].[Fiscal Year].currentmember},[Measures].[Status])
SELECT [Measures].[Status Sum] ON 0,
{[Date].[Fiscal Year].allmembers} ON 1
from [Adventure Works]

and it gives me the following result

Status Sum
All Periods 89898
FY 2002 4260
FY 2003 10799
FY 2004 87377
FY 2005 89898

Now I want to recreate the same calculation in the cube using the CREATE CELL statement and this is what I came up with

CREATE CELL Calculation CURRENTCUBE.[Status Sum] FOR '([Measures].[Status Sum],[date].[Fiscal Year].children,leaves([Customer]))'
AS Aggregate({NULL:[date].[Fiscal Year].currentmember},[Measures].[Status])

This gives me the correct result when I view the [Status Sum] measure against all the years. But when I look for a particular year like FY2005, the query scoped cell calculation (WITH cell calculation) gives me 89898,

**View Complete Post**

## Enhance SSAS so that a calculation returns multiple cells at once (Excel fill not a single cell but