ejaycognos
Technical User
Here is the scenario ..
Level 1 (Required Prompt)-> Level 2(Required Prompt)-> Level 3 -> Level 4 -> Level 5 -> Level 6
High Level -> Low Level
In a crosstab with multiple measures , If the user selects Level 3 prompt, the o/p should group by Level 3 and in o/p shows Level 4.
If a user slects Level 4 prompt , the o/p should group by Level 4 and display the o/p from Level 5.
In short , need to create a dynamic prompt.Forget about the group by as it is crosstab it will automatically be grouped.
Now to do this dynamic prompt , should I need to create a conditional variable?
Thanks so much
Level 1 (Required Prompt)-> Level 2(Required Prompt)-> Level 3 -> Level 4 -> Level 5 -> Level 6
High Level -> Low Level
In a crosstab with multiple measures , If the user selects Level 3 prompt, the o/p should group by Level 3 and in o/p shows Level 4.
If a user slects Level 4 prompt , the o/p should group by Level 4 and display the o/p from Level 5.
In short , need to create a dynamic prompt.Forget about the group by as it is crosstab it will automatically be grouped.
Now to do this dynamic prompt , should I need to create a conditional variable?
Thanks so much