I have a cross Tab and I want to create a % Difference column next to the Dollars columns. I think I have to use a caluclated member but I can't get it to work.
The formula I want to create is: (Fall 09-Fall 08)/Fall 08
The Cross Tab looks like this and Fall 09 & Fall 08 are under the field Season.
|
FALL 08 |
|
FALL 09 |
|
|
QTY |
DOLLARS |
QTY |
DOLLARS |
| DIVISION 1 |
100 |
$1,500.00 |
5526 |
$ 82,890.00 |
| DIVISION 2 |
200 |
$3,000.00 |
66 |
$ 990.00 |
| DIVISION 3 |
300 |
$4,500.00 |
24856 |
$372,840.00 |
| TOTAL |
600 |
$9,000.00 |
30448 |
$456,720.00 |
IP Logged