Disable Drill Downs

[cognostechie]

I have a Crosstab where I have Divisions in the Rows and Locations in the columns.

I need Drill-Down to detailed report for a particular Division and a particular Location
so I created Drill-Downs in the Fact Cells, not on Rows or Columns. I also have 'Totals'
of Rows and Columns.

Problem is I don't need the Drill-Down on the Totals. Even if I disable the Drill-Down of
the Totals, the Drill-Down is still enabled. Is there a way to stop the Crosstab from Drilling
down on all the fact cells?

Thanks in advance

[cognostechie]

Nobody ???

Anyway, I found a workaround for the time being...

[IceTea]

Can you share your workaround with us? ;)

[Sreeni P]

Nobody ???

Anyway, I found a workaround for the time being...

try to post ur workaround solution on ur issue

[cognostechie]

Hide the last row for 'Totals'.

Create a copy of the Crosstab so the query and filters remain the same. Put this copy
right below the Crosstab and hide the rows except the 'Total'.

Since the drill-down is on the 1st crosstab, the totals from the 2nd crosstab don't have
the ability to drill-up/down . The user thinks it's just one Crosstab as there is no gap between
them.  ;)