4 MDX Experts ... Previous Year Values and Filter

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top