COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: hiranb on 26 Feb 2009 12:17:34 PM

Title: crosstab report with drill throughs
Post by: hiranb on 26 Feb 2009 12:17:34 PM
Hi
I have a crosstab report with drill throughs from measure field and it opens target report in pdf.
                       year1   year2  year3    Total
Product1            10       5       12               27
Product2             5        5        5               15
----------------------------------------------
total Products    15     10         17              42
Is it possible to have drill through to target report from Total or Total Products  in the same source report. If it is possible,can any one provide info on how to do this?
Thanks,
Hiran.
Title: Re: crosstab report with drill throughs
Post by: NaviGator on 01 Mar 2009 08:11:40 AM
You can drill through from this report if you clicked on the "total Products" but not from the aggregation itself. To do this, just click on "Total Products" and then click on the Drill Definitions icon to define your drill through path.

You can also drill through by clicking on the measure of the crosstab.