Wondered if you might take a look at my problem...
- Show "YTD Ad Cost" as a sum of previous months Ad Cost plus current month.
- How to get the following MDX (or something similar) into my cube more permanently?
I have 3 time hierarchies including [AdDate] [Fiscal Year] which I'm using here. While I have a working MDX Query expression, my hope now is to define
calculated cells that provide the data more permanently through my cube.
Here is the MDX expression that gets me what I want for Fed Fiscal Year
MEMBER [Measures].[YTD Ad Cost] AS
FedFiscal].CurrentMember, [Measures].[Proj Ad Cost])'