Hi,
I need to create a calculated dimension in the cross tab.
I have 3 dimensions in the cross tab - Product and Channel ( row vice). and Year ( Column vice).
For the Channel, Whenever the channel has data as 'Pharma' we have to display as 'Pharma' for the rest of the values which are not Pharma - should be displayed as 'Non Pharma'.
I tried using a caption and case construct, but always returns errors.
Can you please let me know how to do this.
Thanks,
Venu