If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Stopping Running Total line in chart

Started by RomanP, 06 Aug 2009 04:23:50 PM

Previous topic - Next topic

RomanP

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.