COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: RomanP on 06 Aug 2009 04:23:50 PM

Title: Stopping Running Total line in chart
Post by: RomanP on 06 Aug 2009 04:23:50 PM
I have a report that compares forecasted cashflow with the actuals. My forecast goes through a 12 month period and actuals only span, let's say, first 5 months. My query has 2 measures (one for the forecast and one for actuals) + 2 running total calculations (one for each of the 2 measures above). Obviously, the running total for the actuals flat lines after the first 5 months. On the chart I want to show the full 12 months for the forecast curve but for the actuals curve I want to stop after the first 5 months (instead of continuing it as a straight line parallel to the X-axis). Any suggestions would be highly appreciated.