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:(
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: [Qtr] not in (?QTRs?) and the prompt would just be a checkbox list of the available items to exclude.