Re: Previous Year Calc

#1

Thanks Tom, but how would I go about creating a calc member that aggregates specified months?

----- Tom Chester wrote: ----

If I understand correctly, this has nothing to do with last year o
parallelperiod. If you simply query {[2003], [Jan2003], [Feb2003]}, 2003 i
going to show entire year regardless which months displayed. The possibl
remedies are: 1) create a calc member that aggregates specified months
and/or 2) implement "Visual Totals" via dimension security. (Though #
wouldn't solve the problem at hand.

public @ the domain belo
www.tomchester.ne

"Looagerbalsak" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:4DC1BEA0-AE71-49C2-A7B6-7025E0531878 (AT) microsoft (DOT) com..

Quote:

Hello all
I am at my wits end with this problem and have tried numerous calculation
to figure this out but nothing is really working
I want to show the previous year, which is fine I can do that no worries
but when showing in excel it shows me the full year total even when I ma

only have 3 months selected - I want to show the selected months total

Quote:

The MDX I am currently using is right until you look at the totals - ho
do I fix an why does it happen
"(parallelPeriod([Time].[Year]),[Measures].[Act Val])

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Previous Year Calc

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Previous Year Calc - 04-13-2004 , 02:26 AM