SSAS Calculated Member in Pivot Table
 

Hi All,

I have a time intelligence calculated member in an SSAS cube which gives a
year on year growth comparison. This gives the value and its equivelant from
the same time in the previous year. I'd like to be able to use this is an
Excel 2007 Pivot Table but when i drag on the calculation from my date
dimension it only lists the current value and not the previous years value.
Is there i way i can show both on the pivot table and hopefully use this
value in a chart to show lines relating to current and previous years?

Thanks in advance,

Grant