Hi,
I have a nested crosstab with years as columns. I have tree prompt on the report page for year. My data source is a cube. My requirement is that when i select a particular level in the prompt, the report columns should directly show data at that level. For eg, if i select month in the prompt, the column should show month directly. Instead, it is showing column at year level and then I'm drilling down on that column to the month level to see the actual data.
I cant use conditional formatting becasue i have to drill up and down as I like and select the prompt at any level i want. I have tried using functions like descendants, but it works only for some prompts and then it throws an error.
Please help me
R
I have a nested crosstab with years as columns. I have tree prompt on the report page for year. My data source is a cube. My requirement is that when i select a particular level in the prompt, the report columns should directly show data at that level. For eg, if i select month in the prompt, the column should show month directly. Instead, it is showing column at year level and then I'm drilling down on that column to the month level to see the actual data.
I cant use conditional formatting becasue i have to drill up and down as I like and select the prompt at any level i want. I have tried using functions like descendants, but it works only for some prompts and then it throws an error.
Please help me
R