Cannot display measure variance

• arthur langham

  Grasshopper

  Points: 24

  More actions

  December 9, 2008 at 9:47 am

  #126395

  I'm trying to display the difference in a measure from one day to the next in Excel (2007) by setting the value field setting to 'Difference From' with Base field = day and Base item = previous. If my underlying data is a SSAS cube, the value that displays for each cell is #N/A. If my underlying data is a set of records on another worksheet (and I use it to create a pivot table), the value displays correctly. Both data sets are the same.

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

  Thanks in advance.

• arthur langham

  Grasshopper

  Points: 24

  More actions

  December 11, 2008 at 8:17 am

  #911115

  I ended up using a calculated cube field that looks like:

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