Print Page - Custom Calculation In Cross Tab

Title: Custom Calculation In Cross Tab
Post by: damienm on 09 Mar 2008 06:05:40 AM

Hi All,
I have a cross tab for which I need to calculate the % variance, it's set out as below, I tried to create the expression but keep getting an error, any ideas what the expression should read like, revenue and budget are two measures. Any pointers much appreciated.

Current Month               YTD
      Revenue      Budget   (% Var)     Revenue   Budget
Brand     $xx      $xx     ????     $xx

Title: Re: Custom Calculation In Cross Tab
Post by: DSR on 10 Mar 2008 06:06:12 AM

Hi,
Here I didn't get you exactly.. but let me give you some solution

X Y
Pline 2001 2002 2003 Total (Quantity) Revenue (X/Y)*100

A 10 20 30 60 1000 6

B 40 50 60 150 2000 7.5

Total(Year) 50 70 90 210 3000 7

For getting this you need to put solve order=2 on the properties of the last column.

Thanks

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: damienm on 09 Mar 2008 06:05:40 AM