M
Moby
pivottables shows the right value on a calculated element
(Sum(PeriodsToDate([Perioden].[Level 01],[Perioden].CurrentMember),
[Measures].[Wert])
but converting to formula does not show any value. Only when I change
the reference "$B$1" in the formula into the element name "[perioden].
[mrz 2007]", the right value shows up. Perioden is a Parent-Child
Dimension
Excel 2007 SP1 and Analysis Services 2000 SP4
any ideas or help would be very appreciated?
(Sum(PeriodsToDate([Perioden].[Level 01],[Perioden].CurrentMember),
[Measures].[Wert])
but converting to formula does not show any value. Only when I change
the reference "$B$1" in the formula into the element name "[perioden].
[mrz 2007]", the right value shows up. Perioden is a Parent-Child
Dimension
Excel 2007 SP1 and Analysis Services 2000 SP4
any ideas or help would be very appreciated?