COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: hrk551 on 27 Jun 2012 02:01:53 PM

Title: Combination chart - Drill through ?
Post by: hrk551 on 27 Jun 2012 02:01:53 PM
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

Title: Re: Combination chart - Drill through ?
Post by: CoolP on 27 Jun 2012 07:52:26 PM
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