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
Nobody ???
Anyway, I found a workaround for the time being...
Can you share your workaround with us? ;)
Quote from: cognostechie on 11 Oct 2010 05:13:43 PM
Nobody ???
Anyway, I found a workaround for the time being...
try to post ur workaround solution on ur issue
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. ;)