hi,
i want to calculate the diff in revenue in 2006 and 2007 using query calculation.
how can i achieve it???
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'.