SSAS Calculated Member in Pivot Table

G

GSwan

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
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Formula in Pivot Table Filter? 0
Dealing with a Pivot Table (when I don't want to) 0
Formatting SSAS pivot tables to indicate drill through available 0
Additional columns for Pivot table 0
Slicers and Calculated Items in Pivot Table 2
OLAP Pivot Table Calculations 4
Excel 2007 pivot table using analysis services cube as data source 0

Top