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 ..
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...