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].&) ,[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.