I'm attempting to create a calculated member that have aggregates based on a label. Here is one of the items I have tried:

Aggregate(([Project_Task - All Task Levels].[Task Level 1].[Caption].&[8801]) ,[Measures].[Cost Burd Amt])

Where is "8801" is the label of items I want to aggregate.  Anyone have an idea of the proper syntax. The code above fails returning a "#VALUE" error.

Any assistance would be appreciated.

John

Sorry for the delay John.

Have you tried changing the word Aggregate to Sum?

If that's not it, I would capture the MDX query in the MDX tab and then run the MDX query in SQL Server Management Studio. Then if you double click on the problem cell, it will give you the error message explaining what went wrong with the calculation.