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?
Did you try using a data item with case statement. If the parameter passed is revenue then pull revenue else count.
its perfectly working....thanks