Bar chart showing YTD in last column?
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.