COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Poochi62 on 12 Feb 2014 12:07:24 PM

Title: Crosstab Drill Through for specific intersections only
Post by: Poochi62 on 12 Feb 2014 12:07:24 PM
I am trying to perform a drill-through from a cross-tab intersection, but I only want to drill-thorugh for certain data values only.  Here is my example:

                         Status              Jan        Feb        Mar

Sales Order         On-time         $1,200    $1,500   $1,100
Sales Order          Late                 $600       $700      $500
                                                    ------     ------    -------
Totals                                       $1,800    $2,200    $1,600

I want to drill through on the 'Late' details only (the $600, $700 & $500 values) so I am passing the data parameters for Month and Status.  When I unlock the Crosstab Intersection to define the drill-through definition, the drill-through will be available for both 'On-time' and 'Late' rows as well as the Totals.  I only want it to be drill-able for the 'Late' rows.

Thanks.