ejaycognos
Technical User
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
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