Bar chart showing YTD in last column?

Hi everyone,


I have a bar chart where I'm showing a sum of a variable for each month in the year, with the months populated as we reach each month.  I also wanted to show the YTD (cumulative) value and I've found the approach for adding cumulative sum to a visualization:  Sum([volume]) then Sum([Value]) over (AllPrevious([Axis.X]))


However, I'd like to only show that cumulative sum at the end of the most recent month.  For example, in January I'd have a single bar showing for January's sum, then in February I'd have one bar for February's sum and another bar representing Jan+Feb.


I tried using a conditional expression in the Sum OVER custom expression, but Spotfire didn't seem to like that.


Does anyone know of another way to do this?  Thanks.




(1) Answer