COnditional Block in cross tab

[mrcool]

Hi Frnds,

                  Iam trying to use Conditional block in cross tab n its throwing the error Unable 2 build the cube.

Steps I folloed:
1)I have a value prompt with static choices like month,YTD,CM VS LCM,YTD VS LYYTDetc in prompt page
2) In variable I wrote condition like If Paramdisplayvalue('-----')='Month' then 1 n so on
3)I draged condtional block into the measures and trying to show the columns accoring to Prompts selected.
4)I have 2 measures in the Crosstab.With 1 measure its working fine.But Wen Drag the second measure,Iam facing this error.

Thanks in advance

[ajax6262]

I'm not sure if what you are trying will work or not, but what I would recommend that instead of putting a conditional block in the measures, create a separate cross-tab report for reach parameter.  Pull each of those crosstabs into a conditional block, and let the parameter determine which cross-tab the report shows.

[mrcool]

I have drill down to the same report to get the lower levels of hierachy.So Iam using conditional block for that.I cant use conditional block for every prompt.
Plz tell me is there any bug in crosstab,that conditional bock doesnt work with 2 measures.


Thanks,
Sudheer.Ch

[mrcool]

My prob got solved...Its the the problem with measures I picked.
I used Case condition in the measure inorder to change the value according to Prompt selected.