Calculation in Columns with Multiple Measures in Rows

[godawgs85]

Hi Everyone,

I have a quick question regarding crosstabs and creating a calculation in columns.  Currently my crosstab is set up as follows:

                  Date1   Date2  Calculation
Measure A       #        #             ?
Measure B       #        #             ?
Measure C       #        #             ?

with separate Measures (A,B, & C) on the rows and two time frames (Date1 & Date2) in the Columns.  What I would like to do is create a simple yoy variance calculation in the Calculation column (?).  The structure of the formula will be the same except irrespective of measure but obviously the measures are different in each row.  Is this possible?  Thus, can you create calculations off of values within cells as opposed to the Measures themselves?

Thanks!

Tyler

[MFGF]

Hi,

You don't say whether you are using a dimensional or relational package. If you are using a dimensional package this is really (really) easy - your calculation is simply [Date2 member] - [Date1 member]

Cheers!

MF.