Clever Geek Handbook

Can't display dimension variance in Excel pivot table

I am trying to display the difference in dimension from one day to the next in Excel (2007) by setting the value field to "Difference From" with Base = day and Base = previous. If my underlying data is an SSAS cube, the value displayed for each cell is # N / A. If my underlying data is a set of records in another sheet (and I'm using that to create a pivot table) the value is displayed correctly. Both datasets are the same.

Do I need to create a calculated field of the cube, or am I missing something?

Thanks in advance.

0


source to share


1 answer


I ended up using a computed cube field that looks like this:



([Current day]. [Day]. Current participant, [Measures]. [Volume]) - ([Current day]. [Day] .CurrentMember.Lag (1), [Measures]. [Volume])

+1


source






More articles:


All Articles