I'm trying to display the month over month difference within...

Hello, I'm trying to display the month over month difference within a 6 year time span (2010 - 2015) in Spotffire but no data is showing for January. I know Jan 2010 should be blank since there is no Dec 2009 data but the others should be populated with data. Here is the formula I'm using: Sum([Total_Claims]) THEN [Value] - First([Value]) OVER (NavigatePeriod([Axis.Columns],"Month",-1)) . Any help would be appreciated.

(1) Answer

Login