query calculation

[utathyaghosh]

hi,
i want to calculate the diff in revenue in 2006 and 2007 using query calculation.
how can i achieve it???

[blom0344]

total
(
case when [year] = 2007 then [revenue] else 0 end
)
-
total
(
case when [year] = 2006 then [revenue] else 0 end
)

set the aggregate of the calculation to 'calculated'.