Drillthrough from Crosstab Fact Intersection Issue

[cognos_dev]

Hi All,

I have a set of drill through reports and the parent report is a crosstab. This has person details as its rows and year & month as its columns. the intersection fact is the amount. also there is a grand total for the columns meaning total of years. The user will drill through from the fact, I am passing person id, year and month for each month and person to child report.

Problem is the crosstab fact cells also includes the grand total (total of years) and it doesnt pass any value. I am not able to restrict this column from showing as a drillthrough hyperlink. Is there a way to restrict this column? or allow years to be passed through when user clicks the fact total hyperlink.

Please reply.

Regards,
S