Crosstab Calculation ..

[NaviGator]

Hello Team,

I have a crosstab that contains the revenue as the default measure, product in the rows and years in the column. The user can select 2 different years to be shown  by using 2 prompts. I have created another calculation to get the difference between the revenue for the selected years.

Till now everything is working fine. The issue is that I would like to
have another column that will give some kind of grades for this difference like the following ,

case
when YearDiff > 0 Then 'Good'
else 'Bad'
end

I have created a data item that contain this calculation but it is not working. I have tried to play with it but no luck. It keep gives me errors.

My question is, can i do this in a crosstab? are there any different ways to do this?

Thanks ..

[surendar]

What exactly u did in the query i mean the revenue cal based on 2 year diff.
Can u give more light on this.So that i will get more clarity and try to give inputs...