Dynamic Measures

[deepak2k2]

Hi,

I need to create a crosstab with dynamic measures.

Ex:  If I select "Revenue" in value prompt, cross tab will show revenue, and if i select "Count" it should show count.

I know it could be done in conditional block.  Is there any other solution?

[Ann]

Did you try using a data item with case statement. If the parameter passed is revenue then pull revenue else count.

[deepak2k2]

its perfectly working....thanks