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

Combination chart - Drill through ?

Started by hrk551, 27 Jun 2012 02:01:53 PM

Previous topic - Next topic

hrk551

Hello,

In a combination chart I am taking a bar and a line where bar shows the amount for each month and Line shows the running total, ex:Bar: jan- 5m, Feb - 10m, Mar - 10M, april-5M
And created a drill through definition on month and when someone clicks on Feb (bar) , target report comes up with 10m.
How can we get 15m (Jan+Feb) when clicked on the dot which represents running total till Feb.


Regards
HRK


CoolP

Hi,
Use the running total function in the target report to compute running total till the selected month.
Tip: Use a date range filter and set the FROM date to "Start of the Year" and TO date as the parameter value passed from the chart.

Hope this helps!!!

Thanks
Prasan
CoolP
Aspiring BI/Cognos Professional