Custom Calculation In Cross Tab

[damienm]

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

[DSR]

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