Hi there,
Hopefully this is an easy one. I've set up a chart with time along the x axis, a default measure, and two elements in the series, Actual and Budget. Actual is the bar and Budget is the line. Actual has data for all months, however for the first six months of my time series, the budget value is zero (which is correct).
The problem I have is that when I render the report, the zeros are showing up, and so the line runs along the x axis for the first six months, then jumps up to the first budget value.
Is there a way (as with Excel) to start the line only from where the budget values begin? I've used suppression (series and categories), but doesn't seem to work, I assume because there are values in Actual for the first six months.
Any help would be greatly appreciated.