Hello,
I have a nested crosstab with 3 row layers, N1, N2, N3. I would like the user to run the report and dynamically select the rows they would like to see in their report. They could potentially choose any combination depending on their report needs.
When I try to use conditional formatting and setting box type to 'None', the rows that are displayed shift to the left and hence are not aligning with the columns across the top. Not even sure this is the right way to do it since if N1 is hidden and N2 and N3 are displayed, N2 should be the "highest group", i.e. N2 should not be grouped by N1.
Any suggestions?
It probably makes sense to build a series of crosstabs using different combinations of rows, then conditionally hide the ones which are not relevant based on the prompt values selected. You can use conditional blocks for this.
Regards,
MF.
MF thanks, but that would not be resonable for my requirements. I actually simplified the example, as there are 6 columns to choose from which would increase the number of combinations.
I came up with a solution to use a prompt per row, i.e. 6 prompts with conditional formatting for each row. The conditional formatting is setting foreground and background to white, and setting the sizes to 0 px.