how to hide cross tab row based on prompt value without messing up the column ti

[jaya_e]

how to hide cross tab row based on prompt value without messing up the column title??

I did:
I created a boolean variable
on report page,
clicked on the row which I want to hide.
set the boolean variable to style variable
select box type = none.

o/p:
the required row was hidden based on prompt :)
but the measures have moved to left one cell , which leaves the last column as extra column with no data.:(

___________Qtr1_____Qtr2_____Qtr3
Div. Reg. Dist. 1%_____2%_____3%
Div. Reg. Dist. 4%_____5%_____6%


_____________Qtr1_____Qtr2_____Qtr3
Reg. Dist. 1%_____2%_____3%
Reg. Dist. 4%_____5%_____6%

please help:(

[CognosPaul]

Is there a reason you're not using this prompt to filter out the data in the source?

You could have an optional filter like:

Code Select Expand

[Qtr] not in (?QTRs?) and the prompt would just be a checkbox list of the available items to exclude.