Suppress totals for Time Levels -
04-08-2004
, 02:06 PM
Hello,
I have been using a Virtual time dimension based on Fiscal
Yr, and FiscalWK
I would like to exclude the automatic aggregation
done at the All and FiscalYr levels.
a) The All Level is greyed out which precludes that I
exclude it.
b) I do not wish to remove the Fiscal Yr level because it
affects the LastPeriods function nor make it not visible
c) I am calculating moving averages. Here is a sample MDX
Iif(
Count(LastPeriods(4,[Time].[FiscalYW].CurrentMember))<4,
null,
SUM(LastPeriods(4,[Time].[FiscalYW].CurrentMember ),
([Trend].&[No Trend]) )
/4
Thanks |