Difference in separate block

[karkia]

Hi,
I am using BO WebI ver.11 and Oracle9i. I need to generate a report such as-

DECEMBER 2005
STORE PRODUCT_UNITS_SOLD
----- ------------------
store1 10
store2 0
store3 50
TOTAL:60

NOVEMBER 2005
STORE PRODUCT_UNITS_SOLD
----- ------------------
store1 4
store2 5
store3 20
TOTAL:29

DIFFERENCE IN MONTH SALES (DEC-NOV,2005)
STORE PRODUCT_UNITS_SOLD
----- ------------------
store1 6
store2 -5
store3 30
TOTAL:31

My question is can I store the above units such that I can just perform the difference as a computation in report and not have to query the database to perform the subtraction between the two?

 

[skrandel]

You really can't do this in XIR1. In XI R2, it's very easy.

Steve Krandel
Symantec

 

[karkia]

But Steve, thre must be a way out to achieve this in XI R1 as well. Or may be some tweaking elsewhere? Can u suggest?

 

[skrandel]

Trust me. WebI XI is simply WebI 6.5. This version does not have the ability to do this because it doesn't have a "where" operator at the report-level.

Steve Krandel
Symantec