M
Monte
Hi,
I'm having a problem concerning diplaying Previous Year Values when a Filter
is set on time dimension.
Lets assume a company has quarterly sales of exactly 1000.- in 2003 and 2004.
The Pivot-Table filtered on the first 3 quarters looks as follows:
SALES S_YTD S_PREV S_PREV_YTD
2004
Q1 1000 1000 1000 1000
Q2 1000 2000 1000 2000
Q3 1000 3000 1000 3000
SUM 2004 3000 3000 4000 4000
==== ====
As you can see, the values for Sales Previous Year (YTD) are calculated on
the total of 2003 as for sure is correct concerning my formula for Prev. Year
Values:
([MEASURES].[Sales], ParalellPeriode([TIME].[YEAR],1))
How does the MDX-formula havo to look like, when previous values measures
should also care about the Filter set in current year ... displaying
following information:
SALES S_YTD S_PREV S_PREV_YTD
2004
Q1 1000 1000 1000 1000
Q2 1000 2000 1000 2000
Q3 1000 3000 1000 3000
SUM 2004 3000 3000 3000 3000
==== ====
Thx in advance for your appreciated answer
Monte
I'm having a problem concerning diplaying Previous Year Values when a Filter
is set on time dimension.
Lets assume a company has quarterly sales of exactly 1000.- in 2003 and 2004.
The Pivot-Table filtered on the first 3 quarters looks as follows:
SALES S_YTD S_PREV S_PREV_YTD
2004
Q1 1000 1000 1000 1000
Q2 1000 2000 1000 2000
Q3 1000 3000 1000 3000
SUM 2004 3000 3000 4000 4000
==== ====
As you can see, the values for Sales Previous Year (YTD) are calculated on
the total of 2003 as for sure is correct concerning my formula for Prev. Year
Values:
([MEASURES].[Sales], ParalellPeriode([TIME].[YEAR],1))
How does the MDX-formula havo to look like, when previous values measures
should also care about the Filter set in current year ... displaying
following information:
SALES S_YTD S_PREV S_PREV_YTD
2004
Q1 1000 1000 1000 1000
Q2 1000 2000 1000 2000
Q3 1000 3000 1000 3000
SUM 2004 3000 3000 3000 3000
==== ====
Thx in advance for your appreciated answer
Monte